/*
 Navicat MySQL Data Transfer

 Source Server         : mysql8
 Source Server Type    : MySQL
 Source Server Version : 80026
 Source Host           : 192.168.40.42:3306
 Source Schema         : salary

 Target Server Type    : MySQL
 Target Server Version : 80026
 File Encoding         : 65001

 Date: 13/03/2025 17:31:40
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for fa_admin
-- ----------------------------
DROP TABLE IF EXISTS `fa_admin`;
CREATE TABLE `fa_admin` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `username` varchar(20) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '用户名',
  `nickname` varchar(50) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '昵称',
  `password` varchar(32) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '密码',
  `salt` varchar(30) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '密码盐',
  `avatar` varchar(255) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '头像',
  `email` varchar(100) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '电子邮箱',
  `mobile` varchar(11) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '手机号码',
  `loginfailure` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '失败次数',
  `logintime` bigint DEFAULT NULL COMMENT '登录时间',
  `loginip` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '登录IP',
  `createtime` bigint DEFAULT NULL COMMENT '创建时间',
  `updatetime` bigint DEFAULT NULL COMMENT '更新时间',
  `token` varchar(59) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT 'Session标识',
  `status` varchar(30) COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'normal' COMMENT '状态',
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='管理员表';

-- ----------------------------
-- Records of fa_admin
-- ----------------------------
BEGIN;
INSERT INTO `fa_admin` VALUES (1, 'admin', 'Admin', '29378cc7c5bbca8660de691dc353e2c2', '29c4d0', 'http://salary.com/assets/img/avatar.png', 'admin@admin.com', '', 0, 1741852994, '172.18.0.1', 1491635035, 1741852994, 'b231d89b-087c-4bfc-a5aa-21927cce0876', 'normal');
COMMIT;

-- ----------------------------
-- Table structure for fa_admin_log
-- ----------------------------
DROP TABLE IF EXISTS `fa_admin_log`;
CREATE TABLE `fa_admin_log` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `admin_id` int unsigned NOT NULL DEFAULT '0' COMMENT '管理员ID',
  `username` varchar(30) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '管理员名字',
  `url` varchar(1500) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '操作页面',
  `title` varchar(100) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '日志标题',
  `content` longtext COLLATE utf8mb4_general_ci NOT NULL COMMENT '内容',
  `ip` varchar(50) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT 'IP',
  `useragent` varchar(255) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT 'User-Agent',
  `createtime` bigint DEFAULT NULL COMMENT '操作时间',
  PRIMARY KEY (`id`),
  KEY `name` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=167 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='管理员日志表';

-- ----------------------------
-- Records of fa_admin_log
-- ----------------------------
BEGIN;
INSERT INTO `fa_admin_log` VALUES (1, 1, 'admin', '/XMNAipYcxS.php/staff/contract/ids/1?dialog=1', '员工管理', '{\"dialog\":\"1\",\"row\":{\"name\":\"张三\",\"gender\":\"1\",\"mobile\":\"17086263668\",\"idcard\":\"37068219660429271X\",\"currentAddress\":\"山东烟台\",\"permanentAddress\":\"山东青岛\",\"urgent_name\":\"答复\",\"urgent_mobile\":\"14444444444\",\"contract_start_date\":\"2024-12-06\",\"contract_end_date\":\"2025-12-06\",\"internship_months\":\"3\",\"internship_start_date\":\"2024-12-06\",\"internship_end_date\":\"2025-03-06\"},\"ids\":\"1\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36', 1733464861);
INSERT INTO `fa_admin_log` VALUES (2, 1, 'admin', '/XMNAipYcxS.php/staff/cancelcontract', '员工管理', '{\"flowid\":\"yDCYuUU5wyfj20Uus4BJXv65r02sBnts\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36', 1733464906);
INSERT INTO `fa_admin_log` VALUES (3, 0, 'Unknown', '/jTkNfVxJQm.php/index/login', '', '{\"__token__\":\"***\",\"username\":\"admin\",\"password\":\"***\",\"captcha\":\"U3hz\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36', 1733908647);
INSERT INTO `fa_admin_log` VALUES (4, 1, 'admin', '/jTkNfVxJQm.php/index/login', '登录', '{\"__token__\":\"***\",\"username\":\"admin\",\"password\":\"***\",\"captcha\":\"tjki\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36', 1733908651);
INSERT INTO `fa_admin_log` VALUES (5, 0, 'Unknown', '/XMNAipYcxS.php/index/login', '', '{\"__token__\":\"***\",\"username\":\"admin\",\"password\":\"***\",\"captcha\":\"cwun\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36', 1733908744);
INSERT INTO `fa_admin_log` VALUES (6, 1, 'admin', '/XMNAipYcxS.php/index/login', '登录', '{\"__token__\":\"***\",\"username\":\"admin\",\"password\":\"***\",\"captcha\":\"jdhk\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36', 1733908748);
INSERT INTO `fa_admin_log` VALUES (7, 1, 'admin', '/XMNAipYcxS.php/index/login', '登录', '{\"__token__\":\"***\",\"username\":\"admin\",\"password\":\"***\",\"captcha\":\"acmd\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36', 1736242949);
INSERT INTO `fa_admin_log` VALUES (8, 1, 'admin', '/XMNAipYcxS.php/index/login', '登录', '{\"__token__\":\"***\",\"username\":\"admin\",\"password\":\"***\",\"captcha\":\"qn22\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36', 1736852643);
INSERT INTO `fa_admin_log` VALUES (9, 0, 'Unknown', '/XMNAipYcxS.php/index/login', '', '{\"__token__\":\"***\",\"username\":\"admin\",\"password\":\"***\",\"captcha\":\"btpq\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1740726504);
INSERT INTO `fa_admin_log` VALUES (10, 1, 'admin', '/XMNAipYcxS.php/index/login', '登录', '{\"__token__\":\"***\",\"username\":\"admin\",\"password\":\"***\",\"captcha\":\"qrdd\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1740726507);
INSERT INTO `fa_admin_log` VALUES (11, 1, 'admin', '/XMNAipYcxS.php/company/del', '公司管理 / 删除', '{\"action\":\"del\",\"ids\":\"1\",\"params\":\"\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1740728310);
INSERT INTO `fa_admin_log` VALUES (12, 1, 'admin', '/XMNAipYcxS.php/company/del', '公司管理 / 删除', '{\"action\":\"del\",\"ids\":\"2\",\"params\":\"\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1740728312);
INSERT INTO `fa_admin_log` VALUES (13, 1, 'admin', '/XMNAipYcxS.php/company/add?dialog=1', '公司管理 / 添加', '{\"dialog\":\"1\",\"row\":{\"name\":\"上海申瑞人力资源有限公司\",\"weigh\":\"0\"}}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1740728321);
INSERT INTO `fa_admin_log` VALUES (14, 1, 'admin', '/XMNAipYcxS.php/company/add?dialog=1', '公司管理 / 添加', '{\"dialog\":\"1\",\"row\":{\"name\":\"安徽酷驰人力资源有限公司\",\"weigh\":\"0\"}}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1740728330);
INSERT INTO `fa_admin_log` VALUES (15, 1, 'admin', '/XMNAipYcxS.php/company/add?dialog=1', '公司管理 / 添加', '{\"dialog\":\"1\",\"row\":{\"name\":\"江西省申瑞人力资源有限公司\",\"weigh\":\"0\"}}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1740728336);
INSERT INTO `fa_admin_log` VALUES (16, 1, 'admin', '/XMNAipYcxS.php/staff/edit/ids/1?dialog=1', '员工管理 / 编辑', '{\"dialog\":\"1\",\"row\":{\"name\":\"张三\",\"gender\":\"1\",\"mobile\":\"17086263668\",\"idcard\":\"37068219660429271X\",\"currentAddress\":\"山东烟台\",\"permanentAddress\":\"山东青岛\",\"urgent_name\":\"答复\",\"urgent_relation\":\"父子\",\"urgent_mobile\":\"14444444444\",\"work_experience\":\"sdfsdfas\",\"bank_cardnum\":\"234235353453\",\"bankName\":\"中国银行\",\"company_id\":\"3\"},\"ids\":\"1\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1740728716);
INSERT INTO `fa_admin_log` VALUES (17, 0, 'Unknown', '/XMNAipYcxS.php/index/login', '', '{\"__token__\":\"***\",\"username\":\"admin\",\"password\":\"***\",\"captcha\":\"rkbm\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1741588424);
INSERT INTO `fa_admin_log` VALUES (18, 1, 'admin', '/XMNAipYcxS.php/index/login', '登录', '{\"__token__\":\"***\",\"username\":\"admin\",\"password\":\"***\",\"captcha\":\"tepv\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1741588432);
INSERT INTO `fa_admin_log` VALUES (19, 1, 'admin', '/XMNAipYcxS.php/ajax/upload2', '', '', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1741588444);
INSERT INTO `fa_admin_log` VALUES (20, 1, 'admin', '/XMNAipYcxS.php/salary/getxlsxlist', '工资管理', '', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1741588444);
INSERT INTO `fa_admin_log` VALUES (21, 1, 'admin', '/XMNAipYcxS.php/salary/edit/ids/1?dialog=1', '工资管理 / 编辑', '{\"dialog\":\"1\",\"row\":{\"name\":\"张三\",\"idcard\":\"3706881993111142730\",\"mobile\":\"17086263668\",\"company_name\":\"腾讯\",\"year\":\"2025\",\"month\":\"1\",\"other\":[{\"name\":\"基本工资\",\"value\":\"¥15000\"},{\"name\":\"岗位津贴\",\"value\":\"2000\"},{\"name\":\"绩效奖金\",\"value\":\"5000\"},{\"name\":\"交通补贴\",\"value\":\"500\"},{\"name\":\"餐饮补贴\",\"value\":\"800\"},{\"name\":\"实发工资\",\"value\":\"23300\"},{\"name\":\"其它项目1\",\"value\":\"2222\"},{\"name\":\"其它项目2\",\"value\":\"1111\"}]},\"ids\":\"1\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1741588455);
INSERT INTO `fa_admin_log` VALUES (22, 1, 'admin', '/XMNAipYcxS.php/company/edit/ids/3?dialog=1', '公司管理 / 编辑', '{\"dialog\":\"1\",\"row\":{\"name\":\"上海申瑞人力资源有限公司\",\"operatorUserId\":\"yDCdcUU5kdd02vUudgixHJvCvLhqBD2C\",\"serverSignSealId\":\"yDCYLUU5v3nc1jUqzfmxuBhJ6pT3jy8u\",\"weigh\":\"3\"},\"ids\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1741595441);
INSERT INTO `fa_admin_log` VALUES (23, 1, 'admin', '/XMNAipYcxS.php/company/edit/ids/4?dialog=1', '公司管理 / 编辑', '{\"dialog\":\"1\",\"row\":{\"name\":\"安徽酷驰人力资源有限公司\",\"operatorUserId\":\"111\",\"serverSignSealId\":\"222\",\"weigh\":\"4\"},\"ids\":\"4\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1741595448);
INSERT INTO `fa_admin_log` VALUES (24, 1, 'admin', '/XMNAipYcxS.php/company/edit/ids/5?dialog=1', '公司管理 / 编辑', '{\"dialog\":\"1\",\"row\":{\"name\":\"江西省申瑞人力资源有限公司\",\"operatorUserId\":\"33\",\"serverSignSealId\":\"44\",\"weigh\":\"5\"},\"ids\":\"5\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1741595451);
INSERT INTO `fa_admin_log` VALUES (25, 1, 'admin', '/XMNAipYcxS.php/index/login', '登录', '{\"__token__\":\"***\",\"username\":\"admin\",\"password\":\"***\",\"captcha\":\"5qhy\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1741656803);
INSERT INTO `fa_admin_log` VALUES (26, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"4\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1741660136);
INSERT INTO `fa_admin_log` VALUES (27, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1741660148);
INSERT INTO `fa_admin_log` VALUES (28, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"5\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1741660151);
INSERT INTO `fa_admin_log` VALUES (29, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"4\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1741660156);
INSERT INTO `fa_admin_log` VALUES (30, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1741660159);
INSERT INTO `fa_admin_log` VALUES (31, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"4\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1741660162);
INSERT INTO `fa_admin_log` VALUES (32, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"5\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1741660165);
INSERT INTO `fa_admin_log` VALUES (33, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"4\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1741660168);
INSERT INTO `fa_admin_log` VALUES (34, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1741660171);
INSERT INTO `fa_admin_log` VALUES (35, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"5\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1741660174);
INSERT INTO `fa_admin_log` VALUES (36, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"4\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1741660177);
INSERT INTO `fa_admin_log` VALUES (37, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1741660273);
INSERT INTO `fa_admin_log` VALUES (38, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1741660409);
INSERT INTO `fa_admin_log` VALUES (39, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1741660438);
INSERT INTO `fa_admin_log` VALUES (40, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"4\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1741660444);
INSERT INTO `fa_admin_log` VALUES (41, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1741660448);
INSERT INTO `fa_admin_log` VALUES (42, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1741660547);
INSERT INTO `fa_admin_log` VALUES (43, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1741660564);
INSERT INTO `fa_admin_log` VALUES (44, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1741660733);
INSERT INTO `fa_admin_log` VALUES (45, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1741661152);
INSERT INTO `fa_admin_log` VALUES (46, 1, 'admin', '/XMNAipYcxS.php/staff/contract/ids/1?dialog=1', '员工管理', '{\"dialog\":\"1\",\"row\":{\"name\":\"张三\",\"gender\":\"1\",\"mobile\":\"17086263668\",\"idcard\":\"37068219660429271X\",\"currentAddress\":\"山东烟台\",\"permanentAddress\":\"山东青岛\",\"urgent_name\":\"答复\",\"urgent_mobile\":\"14444444444\",\"contract_start_date\":\"2024-12-06\",\"contract_end_date\":\"2025-12-06\",\"internship_months\":\"3\",\"internship_start_date\":\"2024-12-06\",\"internship_end_date\":\"2025-03-06\",\"company_id\":\"3\",\"templateId\":\"0\"},\"ids\":\"1\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1741661158);
INSERT INTO `fa_admin_log` VALUES (47, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1741661196);
INSERT INTO `fa_admin_log` VALUES (48, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1741661227);
INSERT INTO `fa_admin_log` VALUES (49, 1, 'admin', '/XMNAipYcxS.php/staff/contract/ids/1?dialog=1', '员工管理', '{\"dialog\":\"1\",\"row\":{\"name\":\"张三\",\"gender\":\"1\",\"mobile\":\"17086263668\",\"idcard\":\"37068219660429271X\",\"currentAddress\":\"山东烟台\",\"permanentAddress\":\"山东青岛\",\"urgent_name\":\"答复\",\"urgent_mobile\":\"14444444444\",\"contract_start_date\":\"2024-12-06\",\"contract_end_date\":\"2025-12-06\",\"internship_months\":\"3\",\"internship_start_date\":\"2024-12-06\",\"internship_end_date\":\"2025-03-06\",\"company_id\":\"3\",\"templateId\":\"yDCYLUU5v3nc1jUqzfmxuBhJ6pT3jy8u\"},\"ids\":\"1\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1741661244);
INSERT INTO `fa_admin_log` VALUES (50, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1741661508);
INSERT INTO `fa_admin_log` VALUES (51, 1, 'admin', '/XMNAipYcxS.php/staff/contract/ids/1?dialog=1', '员工管理', '{\"dialog\":\"1\",\"row\":{\"name\":\"张三\",\"gender\":\"1\",\"mobile\":\"17086263668\",\"idcard\":\"37068219660429271X\",\"currentAddress\":\"山东烟台\",\"permanentAddress\":\"山东青岛\",\"urgent_name\":\"答复\",\"urgent_mobile\":\"14444444444\",\"contract_start_date\":\"2024-12-06\",\"contract_end_date\":\"2025-12-06\",\"internship_months\":\"3\",\"internship_start_date\":\"2024-12-06\",\"internship_end_date\":\"2025-03-06\",\"company_id\":\"3\",\"templateId\":\"yDCYLUU5v3nc1jUqzfmxuBhJ6pT3jy8u\"},\"ids\":\"1\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1741661525);
INSERT INTO `fa_admin_log` VALUES (52, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1741661540);
INSERT INTO `fa_admin_log` VALUES (53, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1741661676);
INSERT INTO `fa_admin_log` VALUES (54, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1741661681);
INSERT INTO `fa_admin_log` VALUES (55, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1741661702);
INSERT INTO `fa_admin_log` VALUES (56, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1741661774);
INSERT INTO `fa_admin_log` VALUES (57, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1741661895);
INSERT INTO `fa_admin_log` VALUES (58, 1, 'admin', '/XMNAipYcxS.php/staff/cancelcontract', '员工管理', '{\"flowid\":\"yDtCsUUl7d9xpkUylhbd4vekeSdXTpjD\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1741661897);
INSERT INTO `fa_admin_log` VALUES (59, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1741661901);
INSERT INTO `fa_admin_log` VALUES (60, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1741661956);
INSERT INTO `fa_admin_log` VALUES (61, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 1741676136);
INSERT INTO `fa_admin_log` VALUES (62, 1, 'admin', '/XMNAipYcxS.php/index/login', '登录', '{\"__token__\":\"***\",\"username\":\"admin\",\"password\":\"***\",\"captcha\":\"fnil\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741762203);
INSERT INTO `fa_admin_log` VALUES (63, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741762212);
INSERT INTO `fa_admin_log` VALUES (64, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741768378);
INSERT INTO `fa_admin_log` VALUES (65, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"4\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741768388);
INSERT INTO `fa_admin_log` VALUES (66, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"5\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741768391);
INSERT INTO `fa_admin_log` VALUES (67, 1, 'admin', '/XMNAipYcxS.php/staff/edit/ids/1?dialog=1', '员工管理 / 编辑', '{\"dialog\":\"1\",\"row\":{\"name\":\"张三\",\"gender\":\"1\",\"mobile\":\"17685435572\",\"idcard\":\"37068219660429271X\",\"currentAddress\":\"山东烟台\",\"permanentAddress\":\"山东青岛\",\"urgent_name\":\"答复\",\"urgent_relation\":\"父子\",\"urgent_mobile\":\"14444444444\",\"work_experience\":\"sdfsdfas\",\"bank_cardnum\":\"234235353453\",\"bankName\":\"中国银行\",\"company_id\":\"3\"},\"ids\":\"1\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741768637);
INSERT INTO `fa_admin_log` VALUES (68, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741768641);
INSERT INTO `fa_admin_log` VALUES (69, 1, 'admin', '/XMNAipYcxS.php/staff/contract/ids/1?dialog=1', '员工管理', '{\"dialog\":\"1\",\"row\":{\"name\":\"张三\",\"gender\":\"1\",\"mobile\":\"17685435572\",\"idcard\":\"37068219660429271X\",\"currentAddress\":\"山东烟台\",\"permanentAddress\":\"山东青岛\",\"urgent_name\":\"答复\",\"urgent_mobile\":\"14444444444\",\"contract_start_date\":\"2024-12-06\",\"contract_end_date\":\"2025-12-06\",\"internship_months\":\"3\",\"internship_start_date\":\"2024-12-06\",\"internship_end_date\":\"2025-03-06\",\"company_id\":\"3\",\"templateId\":\"yDtCrUUl7b0a19Uui9ulrvxYij2Yhn6j\"},\"ids\":\"1\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741768651);
INSERT INTO `fa_admin_log` VALUES (70, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741768666);
INSERT INTO `fa_admin_log` VALUES (71, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741768776);
INSERT INTO `fa_admin_log` VALUES (72, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741768814);
INSERT INTO `fa_admin_log` VALUES (73, 1, 'admin', '/XMNAipYcxS.php/staff/cancelcontract', '员工管理', '{\"flowid\":\"yDtCrUUl74mggvUEBinyRBA7ayumQD7C\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741768816);
INSERT INTO `fa_admin_log` VALUES (74, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741768820);
INSERT INTO `fa_admin_log` VALUES (75, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741768828);
INSERT INTO `fa_admin_log` VALUES (76, 1, 'admin', '/XMNAipYcxS.php/staff/contract/ids/1?dialog=1', '员工管理', '{\"dialog\":\"1\",\"row\":{\"name\":\"盖庆超\",\"gender\":\"1\",\"mobile\":\"17685435572\",\"idcard\":\"370682199211142730\",\"currentAddress\":\"山东烟台\",\"permanentAddress\":\"山东青岛\",\"urgent_name\":\"张亮\",\"urgent_mobile\":\"15724956988\",\"contract_start_date\":\"2024-12-06\",\"contract_end_date\":\"2025-12-06\",\"internship_months\":\"3\",\"internship_start_date\":\"2024-12-06\",\"internship_end_date\":\"2025-03-06\",\"company_id\":\"3\",\"templateId\":\"yDtCrUUl7b0a19Uui9ulrvxYij2Yhn6j\"},\"ids\":\"1\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741768870);
INSERT INTO `fa_admin_log` VALUES (77, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741768875);
INSERT INTO `fa_admin_log` VALUES (78, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741769057);
INSERT INTO `fa_admin_log` VALUES (79, 1, 'admin', '/XMNAipYcxS.php/staff/cancelcontract', '员工管理', '{\"flowid\":\"yDtCrUUl74znx8Ux7x1hCup6IfXyHAhp\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741769060);
INSERT INTO `fa_admin_log` VALUES (80, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741769063);
INSERT INTO `fa_admin_log` VALUES (81, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741769228);
INSERT INTO `fa_admin_log` VALUES (82, 1, 'admin', '/XMNAipYcxS.php/staff/contract/ids/1?dialog=1', '员工管理', '{\"dialog\":\"1\",\"row\":{\"name\":\"盖庆超\",\"gender\":\"1\",\"mobile\":\"17685435572\",\"idcard\":\"370682199211142730\",\"currentAddress\":\"山东烟台\",\"permanentAddress\":\"山东青岛\",\"urgent_name\":\"张亮\",\"urgent_mobile\":\"15724956988\",\"contract_start_date\":\"2024-12-06\",\"contract_end_date\":\"2025-12-06\",\"internship_months\":\"3\",\"internship_start_date\":\"2024-12-06\",\"internship_end_date\":\"2025-03-06\",\"company_id\":\"3\",\"templateId\":\"yDtCrUUl7b0a19Uui9ulrvxYij2Yhn6j\"},\"ids\":\"1\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741769234);
INSERT INTO `fa_admin_log` VALUES (83, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741769291);
INSERT INTO `fa_admin_log` VALUES (84, 1, 'admin', '/XMNAipYcxS.php/staff/cancelcontract', '员工管理', '{\"flowid\":\"yDtCrUUl74cz5uUEkW4VyEEJgVcc3HvA\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741769293);
INSERT INTO `fa_admin_log` VALUES (85, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741769297);
INSERT INTO `fa_admin_log` VALUES (86, 1, 'admin', '/XMNAipYcxS.php/staff/contract/ids/1?dialog=1', '员工管理', '{\"dialog\":\"1\",\"row\":{\"name\":\"盖庆超\",\"gender\":\"1\",\"mobile\":\"17685435572\",\"idcard\":\"370682199211142730\",\"currentAddress\":\"山东烟台\",\"permanentAddress\":\"山东青岛\",\"urgent_name\":\"张亮\",\"urgent_mobile\":\"15724956988\",\"contract_start_date\":\"2024-12-06\",\"contract_end_date\":\"2025-12-06\",\"internship_months\":\"3\",\"internship_start_date\":\"2024-12-06\",\"internship_end_date\":\"2025-03-06\",\"company_id\":\"3\",\"templateId\":\"yDtCrUUl7b0a19Uui9ulrvxYij2Yhn6j\"},\"ids\":\"1\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741769368);
INSERT INTO `fa_admin_log` VALUES (87, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741769419);
INSERT INTO `fa_admin_log` VALUES (88, 1, 'admin', '/XMNAipYcxS.php/staff/cancelcontract', '员工管理', '{\"flowid\":\"yDtCrUUl77p6hgUyB0wakxxQCskDAF59\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741769421);
INSERT INTO `fa_admin_log` VALUES (89, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741769432);
INSERT INTO `fa_admin_log` VALUES (90, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741769693);
INSERT INTO `fa_admin_log` VALUES (91, 1, 'admin', '/XMNAipYcxS.php/staff/contract/ids/1?dialog=1', '员工管理', '{\"dialog\":\"1\",\"row\":{\"name\":\"盖庆超\",\"gender\":\"1\",\"mobile\":\"17685435572\",\"idcard\":\"370682199211142730\",\"currentAddress\":\"山东烟台\",\"permanentAddress\":\"山东青岛\",\"urgent_name\":\"张亮\",\"urgent_mobile\":\"15724956988\",\"contract_start_date\":\"2024-12-06\",\"contract_end_date\":\"2025-12-06\",\"internship_months\":\"3\",\"internship_start_date\":\"2024-12-06\",\"internship_end_date\":\"2025-03-06\",\"company_id\":\"3\",\"templateId\":\"yDtCrUUl7bvfqtUucGHGoG3jGmQvsw1O\"},\"ids\":\"1\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741769705);
INSERT INTO `fa_admin_log` VALUES (92, 1, 'admin', '/XMNAipYcxS.php/staff/contract/ids/1?dialog=1', '员工管理', '{\"dialog\":\"1\",\"row\":{\"name\":\"盖庆超\",\"gender\":\"1\",\"mobile\":\"17685435572\",\"idcard\":\"370682199211142730\",\"currentAddress\":\"山东烟台\",\"permanentAddress\":\"山东青岛\",\"urgent_name\":\"张亮\",\"urgent_mobile\":\"15724956988\",\"contract_start_date\":\"2024-12-06\",\"contract_end_date\":\"2025-12-06\",\"internship_months\":\"3\",\"internship_start_date\":\"2024-12-06\",\"internship_end_date\":\"2025-03-06\",\"company_id\":\"3\",\"templateId\":\"yDtCrUUl7bvfqtUucGHGoG3jGmQvsw1O\"},\"ids\":\"1\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741769934);
INSERT INTO `fa_admin_log` VALUES (93, 1, 'admin', '/XMNAipYcxS.php/staff/contract/ids/1?dialog=1', '员工管理', '{\"dialog\":\"1\",\"row\":{\"name\":\"盖庆超\",\"gender\":\"1\",\"mobile\":\"17685435572\",\"idcard\":\"370682199211142730\",\"currentAddress\":\"山东烟台\",\"permanentAddress\":\"山东青岛\",\"urgent_name\":\"张亮\",\"urgent_mobile\":\"15724956988\",\"contract_start_date\":\"2024-12-06\",\"contract_end_date\":\"2025-12-06\",\"internship_months\":\"3\",\"internship_start_date\":\"2024-12-06\",\"internship_end_date\":\"2025-03-06\",\"company_id\":\"3\",\"templateId\":\"yDtCrUUl7bvfqtUucGHGoG3jGmQvsw1O\"},\"ids\":\"1\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741769983);
INSERT INTO `fa_admin_log` VALUES (94, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741769992);
INSERT INTO `fa_admin_log` VALUES (95, 1, 'admin', '/XMNAipYcxS.php/staff/cancelcontract', '员工管理', '{\"flowid\":\"yDtCrUUl778zzaUy4F1YpRHIY0oN4xKy\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741770102);
INSERT INTO `fa_admin_log` VALUES (96, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741770114);
INSERT INTO `fa_admin_log` VALUES (97, 1, 'admin', '/XMNAipYcxS.php/staff/contract/ids/1?dialog=1', '员工管理', '{\"dialog\":\"1\",\"row\":{\"name\":\"盖庆超\",\"gender\":\"1\",\"mobile\":\"17685435572\",\"idcard\":\"370682199211142730\",\"currentAddress\":\"山东烟台\",\"permanentAddress\":\"山东青岛\",\"urgent_name\":\"张亮\",\"urgent_mobile\":\"15724956988\",\"contract_start_date\":\"2024-12-06\",\"contract_end_date\":\"2025-12-06\",\"internship_months\":\"3\",\"internship_start_date\":\"2024-12-06\",\"internship_end_date\":\"2025-03-06\",\"company_id\":\"3\",\"templateId\":\"yDtCrUUl7bvfqtUucGHGoG3jGmQvsw1O\"},\"ids\":\"1\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741770350);
INSERT INTO `fa_admin_log` VALUES (98, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741770428);
INSERT INTO `fa_admin_log` VALUES (99, 1, 'admin', '/XMNAipYcxS.php/staff/cancelcontract', '员工管理', '{\"flowid\":\"yDtCrUUl7714b4Uu2qDkrxotiSGHQ0Qg\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741770431);
INSERT INTO `fa_admin_log` VALUES (100, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741770435);
INSERT INTO `fa_admin_log` VALUES (101, 1, 'admin', '/XMNAipYcxS.php/staff/contract/ids/1?dialog=1', '员工管理', '{\"dialog\":\"1\",\"row\":{\"name\":\"盖庆超\",\"gender\":\"1\",\"mobile\":\"17685435572\",\"idcard\":\"370682199211142730\",\"currentAddress\":\"山东烟台\",\"permanentAddress\":\"山东青岛\",\"urgent_name\":\"张亮\",\"urgent_mobile\":\"15724956988\",\"contract_start_date\":\"2024-12-06\",\"contract_end_date\":\"2025-12-06\",\"internship_months\":\"3\",\"internship_start_date\":\"2024-12-06\",\"internship_end_date\":\"2025-03-06\",\"company_id\":\"3\",\"templateId\":\"yDtCrUUl7bvfqtUucGHGoG3jGmQvsw1O\"},\"ids\":\"1\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741770521);
INSERT INTO `fa_admin_log` VALUES (102, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741770577);
INSERT INTO `fa_admin_log` VALUES (103, 1, 'admin', '/XMNAipYcxS.php/staff/cancelcontract', '员工管理', '{\"flowid\":\"yDtCrUUl77og0jUNCDFbuLef1GbxXcNC\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741770579);
INSERT INTO `fa_admin_log` VALUES (104, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741770583);
INSERT INTO `fa_admin_log` VALUES (105, 1, 'admin', '/XMNAipYcxS.php/staff/contract/ids/1?dialog=1', '员工管理', '{\"dialog\":\"1\",\"row\":{\"name\":\"盖庆超\",\"gender\":\"1\",\"mobile\":\"17685435572\",\"idcard\":\"370682199211142730\",\"currentAddress\":\"山东烟台\",\"permanentAddress\":\"山东青岛\",\"urgent_name\":\"张亮\",\"urgent_mobile\":\"15724956988\",\"contract_start_date\":\"2024-12-06\",\"contract_end_date\":\"2025-12-06\",\"internship_months\":\"3\",\"internship_start_date\":\"2024-12-06\",\"internship_end_date\":\"2025-03-06\",\"company_id\":\"3\",\"templateId\":\"yDtCrUUl7bvfqtUucGHGoG3jGmQvsw1O\"},\"ids\":\"1\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741770763);
INSERT INTO `fa_admin_log` VALUES (106, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741770808);
INSERT INTO `fa_admin_log` VALUES (107, 1, 'admin', '/XMNAipYcxS.php/staff/cancelcontract', '员工管理', '{\"flowid\":\"yDtCrUUl77wr7rUx7x1hCElpvehmFO2R\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741770809);
INSERT INTO `fa_admin_log` VALUES (108, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741770821);
INSERT INTO `fa_admin_log` VALUES (109, 1, 'admin', '/XMNAipYcxS.php/staff/contract/ids/1?dialog=1', '员工管理', '{\"dialog\":\"1\",\"row\":{\"name\":\"盖庆超\",\"gender\":\"1\",\"mobile\":\"17685435572\",\"idcard\":\"370682199211142730\",\"currentAddress\":\"山东烟台\",\"permanentAddress\":\"山东青岛\",\"urgent_name\":\"张亮\",\"urgent_mobile\":\"15724956988\",\"contract_start_date\":\"2024-12-06\",\"contract_end_date\":\"2025-12-06\",\"internship_months\":\"3\",\"internship_start_date\":\"2024-12-06\",\"internship_end_date\":\"2025-03-06\",\"company_id\":\"3\",\"templateId\":\"yDtCrUUl7bvfqtUucGHGoG3jGmQvsw1O\"},\"ids\":\"1\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741770879);
INSERT INTO `fa_admin_log` VALUES (110, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741770916);
INSERT INTO `fa_admin_log` VALUES (111, 1, 'admin', '/XMNAipYcxS.php/staff/cancelcontract', '员工管理', '{\"flowid\":\"yDtCrUUl77y7z5UpkhPpvaFc3iKRsm7R\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741770918);
INSERT INTO `fa_admin_log` VALUES (112, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741770927);
INSERT INTO `fa_admin_log` VALUES (113, 1, 'admin', '/XMNAipYcxS.php/staff/contract/ids/1?dialog=1', '员工管理', '{\"dialog\":\"1\",\"row\":{\"name\":\"盖庆超\",\"gender\":\"1\",\"mobile\":\"17685435572\",\"idcard\":\"370682199211142730\",\"currentAddress\":\"山东烟台\",\"permanentAddress\":\"山东青岛\",\"urgent_name\":\"张亮\",\"urgent_mobile\":\"15724956988\",\"contract_start_date\":\"2024-12-06\",\"contract_end_date\":\"2025-12-06\",\"internship_months\":\"3\",\"internship_start_date\":\"2024-12-06\",\"internship_end_date\":\"2025-03-06\",\"company_id\":\"3\",\"templateId\":\"yDtCrUUl7unz64UEc3ZwnRueWCoLDPCk\"},\"ids\":\"1\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741771133);
INSERT INTO `fa_admin_log` VALUES (114, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741771446);
INSERT INTO `fa_admin_log` VALUES (115, 1, 'admin', '/XMNAipYcxS.php/staff/contract/ids/1?dialog=1', '员工管理', '{\"dialog\":\"1\",\"row\":{\"name\":\"盖庆超\",\"gender\":\"1\",\"mobile\":\"17685435572\",\"idcard\":\"370682199211142730\",\"currentAddress\":\"山东烟台\",\"permanentAddress\":\"山东青岛\",\"urgent_name\":\"张亮\",\"urgent_mobile\":\"15724956988\",\"contract_start_date\":\"2024-12-06\",\"contract_end_date\":\"2025-12-06\",\"internship_months\":\"3\",\"internship_start_date\":\"2024-12-06\",\"internship_end_date\":\"2025-03-06\",\"company_id\":\"3\",\"templateId\":\"yDtCrUUl7unz64UEc3ZwnRueWCoLDPCk\"},\"ids\":\"1\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741771455);
INSERT INTO `fa_admin_log` VALUES (116, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741771515);
INSERT INTO `fa_admin_log` VALUES (117, 1, 'admin', '/XMNAipYcxS.php/staff/cancelcontract', '员工管理', '{\"flowid\":\"yDtCrUUl77kw1oUEZXEGVxGAqTBGbDVH\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741771517);
INSERT INTO `fa_admin_log` VALUES (118, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741771526);
INSERT INTO `fa_admin_log` VALUES (119, 1, 'admin', '/XMNAipYcxS.php/staff/contract/ids/1?dialog=1', '员工管理', '{\"dialog\":\"1\",\"row\":{\"name\":\"盖庆超\",\"gender\":\"1\",\"mobile\":\"17685435572\",\"idcard\":\"370682199211142730\",\"currentAddress\":\"山东烟台\",\"permanentAddress\":\"山东青岛\",\"urgent_name\":\"张亮\",\"urgent_mobile\":\"15724956988\",\"contract_start_date\":\"2024-12-06\",\"contract_end_date\":\"2025-12-06\",\"internship_months\":\"3\",\"internship_start_date\":\"2024-12-06\",\"internship_end_date\":\"2025-03-06\",\"company_id\":\"3\",\"templateId\":\"yDtCrUUl7unz64UEc3ZwnRueWCoLDPCk\"},\"ids\":\"1\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741771658);
INSERT INTO `fa_admin_log` VALUES (120, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741771695);
INSERT INTO `fa_admin_log` VALUES (121, 1, 'admin', '/XMNAipYcxS.php/staff/cancelcontract', '员工管理', '{\"flowid\":\"yDtCrUUl77icqyUuhDzO618iiV01u62d\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741771697);
INSERT INTO `fa_admin_log` VALUES (122, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741771702);
INSERT INTO `fa_admin_log` VALUES (123, 1, 'admin', '/XMNAipYcxS.php/staff/contract/ids/1?dialog=1', '员工管理', '{\"dialog\":\"1\",\"row\":{\"name\":\"盖庆超\",\"gender\":\"1\",\"mobile\":\"17685435572\",\"idcard\":\"370682199211142730\",\"currentAddress\":\"山东烟台\",\"permanentAddress\":\"山东青岛\",\"urgent_name\":\"张亮\",\"urgent_mobile\":\"15724956988\",\"contract_start_date\":\"2024-12-06\",\"contract_end_date\":\"2025-12-06\",\"internship_months\":\"3\",\"internship_start_date\":\"2024-12-06\",\"internship_end_date\":\"2025-03-06\",\"company_id\":\"3\",\"templateId\":\"yDtCrUUl7uhfniUucGHGoEQohYMDr24m\"},\"ids\":\"1\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741771908);
INSERT INTO `fa_admin_log` VALUES (124, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741771973);
INSERT INTO `fa_admin_log` VALUES (125, 1, 'admin', '/XMNAipYcxS.php/staff/cancelcontract', '员工管理', '{\"flowid\":\"yDtCrUUl77c40bUuK4igeNyIKYccOIp8\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741771974);
INSERT INTO `fa_admin_log` VALUES (126, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741771979);
INSERT INTO `fa_admin_log` VALUES (127, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"4\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741772126);
INSERT INTO `fa_admin_log` VALUES (128, 1, 'admin', '/XMNAipYcxS.php/staff/contract/ids/1?dialog=1', '员工管理', '{\"dialog\":\"1\",\"row\":{\"name\":\"盖庆超\",\"gender\":\"1\",\"mobile\":\"17685435572\",\"idcard\":\"370682199211142730\",\"currentAddress\":\"山东烟台\",\"permanentAddress\":\"山东青岛\",\"urgent_name\":\"张亮\",\"urgent_mobile\":\"15724956988\",\"contract_start_date\":\"2024-12-06\",\"contract_end_date\":\"2025-12-06\",\"internship_months\":\"3\",\"internship_start_date\":\"2024-12-06\",\"internship_end_date\":\"2025-03-06\",\"company_id\":\"4\",\"templateId\":\"yDtCrUUl7uq6e3UggQaLRSAYWnzpF2JC\"},\"ids\":\"1\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741772133);
INSERT INTO `fa_admin_log` VALUES (129, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741772753);
INSERT INTO `fa_admin_log` VALUES (130, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"4\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741772755);
INSERT INTO `fa_admin_log` VALUES (131, 1, 'admin', '/XMNAipYcxS.php/staff/contract/ids/1?dialog=1', '员工管理', '{\"dialog\":\"1\",\"row\":{\"name\":\"盖庆超\",\"gender\":\"1\",\"mobile\":\"17685435572\",\"idcard\":\"370682199211142730\",\"currentAddress\":\"山东烟台\",\"permanentAddress\":\"山东青岛\",\"urgent_name\":\"张亮\",\"urgent_mobile\":\"15724956988\",\"contract_start_date\":\"2024-12-06\",\"contract_end_date\":\"2025-12-06\",\"internship_months\":\"3\",\"internship_start_date\":\"2024-12-06\",\"internship_end_date\":\"2025-03-06\",\"company_id\":\"4\",\"templateId\":\"yDtCrUUl7uq6e3UggQaLRSAYWnzpF2JC\"},\"ids\":\"1\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741772758);
INSERT INTO `fa_admin_log` VALUES (132, 1, 'admin', '/XMNAipYcxS.php/index/login', '登录', '{\"__token__\":\"***\",\"username\":\"admin\",\"password\":\"***\",\"captcha\":\"mej8\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741852994);
INSERT INTO `fa_admin_log` VALUES (133, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741853005);
INSERT INTO `fa_admin_log` VALUES (134, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741853190);
INSERT INTO `fa_admin_log` VALUES (135, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741854074);
INSERT INTO `fa_admin_log` VALUES (136, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741855307);
INSERT INTO `fa_admin_log` VALUES (137, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"4\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741855319);
INSERT INTO `fa_admin_log` VALUES (138, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741855321);
INSERT INTO `fa_admin_log` VALUES (139, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741855360);
INSERT INTO `fa_admin_log` VALUES (140, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741855469);
INSERT INTO `fa_admin_log` VALUES (141, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741855510);
INSERT INTO `fa_admin_log` VALUES (142, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741855721);
INSERT INTO `fa_admin_log` VALUES (143, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741855749);
INSERT INTO `fa_admin_log` VALUES (144, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741856241);
INSERT INTO `fa_admin_log` VALUES (145, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741856278);
INSERT INTO `fa_admin_log` VALUES (146, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741856427);
INSERT INTO `fa_admin_log` VALUES (147, 1, 'admin', '/XMNAipYcxS.php/staff/contract/ids/1?dialog=1', '员工管理', '{\"dialog\":\"1\",\"row\":{\"name\":\"盖庆超\",\"gender\":\"1\",\"mobile\":\"17685435572\",\"idcard\":\"370682199211142730\",\"currentAddress\":\"山东烟台\",\"permanentAddress\":\"山东青岛\",\"urgent_name\":\"张亮\",\"urgent_mobile\":\"15724956988\",\"contract_start_date\":\"2024-12-06\",\"contract_end_date\":\"2025-12-06\",\"internship_months\":\"3\",\"internship_start_date\":\"2024-12-06\",\"internship_end_date\":\"2025-03-06\",\"company_id\":\"3\",\"templateId\":\"yDtCrUUl7bvfqtUucGHGoG3jGmQvsw1O\",\"other\":{\"协议编号\":\"a11111\",\"合同期限几年\":\"2\",\"月工资\":\"3000\",\"每月几号发工资\":\"15\"}},\"ids\":\"1\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741857073);
INSERT INTO `fa_admin_log` VALUES (148, 1, 'admin', '/XMNAipYcxS.php/staff/contract/ids/1?dialog=1', '员工管理', '{\"dialog\":\"1\",\"row\":{\"name\":\"盖庆超\",\"gender\":\"1\",\"mobile\":\"17685435572\",\"idcard\":\"370682199211142730\",\"currentAddress\":\"山东烟台\",\"permanentAddress\":\"山东青岛\",\"urgent_name\":\"张亮\",\"urgent_mobile\":\"15724956988\",\"contract_start_date\":\"2024-12-06\",\"contract_end_date\":\"2025-12-06\",\"internship_months\":\"3\",\"internship_start_date\":\"2024-12-06\",\"internship_end_date\":\"2025-03-06\",\"company_id\":\"3\",\"templateId\":\"yDtCrUUl7bvfqtUucGHGoG3jGmQvsw1O\",\"other\":{\"协议编号\":\"a11111\",\"合同期限几年\":\"2\",\"月工资\":\"3000\",\"每月几号发工资\":\"15\"}},\"ids\":\"1\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741857133);
INSERT INTO `fa_admin_log` VALUES (149, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741857236);
INSERT INTO `fa_admin_log` VALUES (150, 1, 'admin', '/XMNAipYcxS.php/staff/contract/ids/1?dialog=1', '员工管理', '{\"dialog\":\"1\",\"row\":{\"name\":\"盖庆超\",\"gender\":\"1\",\"mobile\":\"17685435572\",\"idcard\":\"370682199211142730\",\"currentAddress\":\"山东烟台\",\"permanentAddress\":\"山东青岛\",\"urgent_name\":\"张亮\",\"urgent_mobile\":\"15724956988\",\"contract_start_date\":\"2024-12-06\",\"contract_end_date\":\"2025-12-06\",\"internship_months\":\"3\",\"internship_start_date\":\"2024-12-06\",\"internship_end_date\":\"2025-03-06\",\"company_id\":\"3\",\"templateId\":\"yDtCrUUl7bvfqtUucGHGoG3jGmQvsw1O\",\"other_data\":{\"协议编号\":\"a12356\",\"合同期限几年\":\"3\",\"月工资\":\"5000\",\"每月几号发工资\":\"6\"}},\"ids\":\"1\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741857257);
INSERT INTO `fa_admin_log` VALUES (151, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741857403);
INSERT INTO `fa_admin_log` VALUES (152, 1, 'admin', '/XMNAipYcxS.php/staff/cancelcontract', '员工管理', '{\"flowid\":\"yDtCTUUlx2ko1bUur8jHQ6piHFvGNVYR\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741857405);
INSERT INTO `fa_admin_log` VALUES (153, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741857409);
INSERT INTO `fa_admin_log` VALUES (154, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741857462);
INSERT INTO `fa_admin_log` VALUES (155, 1, 'admin', '/XMNAipYcxS.php/staff/contract/ids/1?dialog=1', '员工管理', '{\"dialog\":\"1\",\"row\":{\"name\":\"盖庆超\",\"gender\":\"1\",\"mobile\":\"17685435572\",\"idcard\":\"370682199211142730\",\"currentAddress\":\"山东烟台\",\"permanentAddress\":\"山东青岛\",\"urgent_name\":\"张亮\",\"urgent_mobile\":\"15724956988\",\"contract_start_date\":\"2024-12-06\",\"contract_end_date\":\"2025-12-06\",\"internship_months\":\"3\",\"internship_start_date\":\"2024-12-06\",\"internship_end_date\":\"2025-03-06\",\"company_id\":\"3\",\"templateId\":\"yDtCrUUl7unz64UEc3ZwnRueWCoLDPCk\",\"other_data\":{\"合同期限几年\":\"6\",\"月工资\":\"7000\",\"试用期月工资\":\"5000\",\"每月几号发工资\":\"20\"}},\"ids\":\"1\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741857485);
INSERT INTO `fa_admin_log` VALUES (156, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741857537);
INSERT INTO `fa_admin_log` VALUES (157, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741857617);
INSERT INTO `fa_admin_log` VALUES (158, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741857633);
INSERT INTO `fa_admin_log` VALUES (159, 1, 'admin', '/XMNAipYcxS.php/staff/cancelcontract', '员工管理', '{\"flowid\":\"yDtCTUUlx2kn35UyEdnFrMDe234jEJA1\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741857746);
INSERT INTO `fa_admin_log` VALUES (160, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741857751);
INSERT INTO `fa_admin_log` VALUES (161, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741857804);
INSERT INTO `fa_admin_log` VALUES (162, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741857834);
INSERT INTO `fa_admin_log` VALUES (163, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741857962);
INSERT INTO `fa_admin_log` VALUES (164, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"4\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741857966);
INSERT INTO `fa_admin_log` VALUES (165, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741857969);
INSERT INTO `fa_admin_log` VALUES (166, 1, 'admin', '/XMNAipYcxS.php/staff/getTemplateIdListByCompanyId', '员工管理', '{\"company_id\":\"3\"}', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 1741858021);
COMMIT;

-- ----------------------------
-- Table structure for fa_area
-- ----------------------------
DROP TABLE IF EXISTS `fa_area`;
CREATE TABLE `fa_area` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `pid` int DEFAULT NULL COMMENT '父id',
  `shortname` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '简称',
  `name` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '名称',
  `mergename` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '全称',
  `level` tinyint DEFAULT NULL COMMENT '层级:1=省,2=市,3=区/县',
  `pinyin` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '拼音',
  `code` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '长途区号',
  `zip` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '邮编',
  `first` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '首字母',
  `lng` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '经度',
  `lat` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '纬度',
  PRIMARY KEY (`id`),
  KEY `pid` (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='地区表';

-- ----------------------------
-- Table structure for fa_attachment
-- ----------------------------
DROP TABLE IF EXISTS `fa_attachment`;
CREATE TABLE `fa_attachment` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `category` varchar(50) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '类别',
  `admin_id` int unsigned NOT NULL DEFAULT '0' COMMENT '管理员ID',
  `user_id` int unsigned NOT NULL DEFAULT '0' COMMENT '会员ID',
  `url` varchar(255) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '物理路径',
  `imagewidth` int unsigned DEFAULT '0' COMMENT '宽度',
  `imageheight` int unsigned DEFAULT '0' COMMENT '高度',
  `imagetype` varchar(30) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '图片类型',
  `imageframes` int unsigned NOT NULL DEFAULT '0' COMMENT '图片帧数',
  `filename` varchar(100) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '文件名称',
  `filesize` int unsigned NOT NULL DEFAULT '0' COMMENT '文件大小',
  `mimetype` varchar(100) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT 'mime类型',
  `extparam` varchar(255) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '透传数据',
  `createtime` bigint DEFAULT NULL COMMENT '创建日期',
  `updatetime` bigint DEFAULT NULL COMMENT '更新时间',
  `uploadtime` bigint DEFAULT NULL COMMENT '上传时间',
  `storage` varchar(100) COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'local' COMMENT '存储位置',
  `sha1` varchar(40) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '文件 sha1编码',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='附件表';

-- ----------------------------
-- Records of fa_attachment
-- ----------------------------
BEGIN;
INSERT INTO `fa_attachment` VALUES (1, '', 1, 0, '/assets/img/qrcode.png', 150, 150, 'png', 0, 'qrcode.png', 21859, 'image/png', '', 1491635035, 1491635035, 1491635035, 'local', '17163603d0263e4838b9387ff2cd4877e8b018f6');
INSERT INTO `fa_attachment` VALUES (2, '', 1, 0, '/salary/excel/2024/工资模版.xlsx', 0, 0, 'xlsx', 0, '工资模版.xlsx', 19456, 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', '', 1732863446, 1732863446, 1732863446, 'local', '3a0ded450a7dedcae2d54d0e3ccf9bfb9d362c2e');
INSERT INTO `fa_attachment` VALUES (3, '', 1, 0, '/uploads/salary/excel/2024/工资模版.xlsx', 0, 0, 'xlsx', 0, '工资模版.xlsx', 19456, 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', '', 1732863598, 1732863598, 1732863598, 'local', '3a0ded450a7dedcae2d54d0e3ccf9bfb9d362c2e');
INSERT INTO `fa_attachment` VALUES (4, '', 1, 0, '/uploads/salary/excel/2024/工资模版2.xlsx', 0, 0, 'xlsx', 0, '工资模版2.xlsx', 19456, 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', '', 1732863962, 1732863962, 1732863962, 'local', 'b76d9caf10748e65ed322c5d9c856fde69509542');
INSERT INTO `fa_attachment` VALUES (5, '', 1, 0, '/uploads/salary/excel/2024/temp.xlsx', 0, 0, 'xlsx', 0, 'temp.xlsx', 19456, 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', '', 1732866298, 1732866298, 1732866298, 'local', '3a0ded450a7dedcae2d54d0e3ccf9bfb9d362c2e');
INSERT INTO `fa_attachment` VALUES (6, '', 1, 0, '/uploads/salary/excel/2024/moban.xlsx', 0, 0, 'xlsx', 0, 'moban.xlsx', 9077, 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', '', 1732880728, 1732880728, 1732880728, 'local', 'fba9f0dc1e2dbdce620f58bc7db3132b51f398a2');
INSERT INTO `fa_attachment` VALUES (7, '', 1, 0, '/uploads/salary/excel/2025/temp2.xlsx', 0, 0, 'xlsx', 0, 'temp2.xlsx', 9243, 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', '', 1741588444, 1741588444, 1741588444, 'local', '573a4f7b4fdc9d1d8f494419b0d96e320385eaf6');
COMMIT;

-- ----------------------------
-- Table structure for fa_auth_group
-- ----------------------------
DROP TABLE IF EXISTS `fa_auth_group`;
CREATE TABLE `fa_auth_group` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `pid` int unsigned NOT NULL DEFAULT '0' COMMENT '父组别',
  `name` varchar(100) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '组名',
  `rules` text COLLATE utf8mb4_general_ci NOT NULL COMMENT '规则ID',
  `createtime` bigint DEFAULT NULL COMMENT '创建时间',
  `updatetime` bigint DEFAULT NULL COMMENT '更新时间',
  `status` varchar(30) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='分组表';

-- ----------------------------
-- Records of fa_auth_group
-- ----------------------------
BEGIN;
INSERT INTO `fa_auth_group` VALUES (1, 0, 'Admin group', '*', 1491635035, 1491635035, 'normal');
INSERT INTO `fa_auth_group` VALUES (2, 1, 'Second group', '13,14,16,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,40,41,42,43,44,45,46,47,48,49,50,55,56,57,58,59,60,61,62,63,64,65,1,9,10,11,7,6,8,2,4,5', 1491635035, 1491635035, 'normal');
INSERT INTO `fa_auth_group` VALUES (3, 2, 'Third group', '1,4,9,10,11,13,14,15,16,17,40,41,42,43,44,45,46,47,48,49,50,55,56,57,58,59,60,61,62,63,64,65,5', 1491635035, 1491635035, 'normal');
INSERT INTO `fa_auth_group` VALUES (4, 1, 'Second group 2', '1,4,13,14,15,16,17,55,56,57,58,59,60,61,62,63,64,65', 1491635035, 1491635035, 'normal');
INSERT INTO `fa_auth_group` VALUES (5, 2, 'Third group 2', '1,2,6,7,8,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34', 1491635035, 1491635035, 'normal');
COMMIT;

-- ----------------------------
-- Table structure for fa_auth_group_access
-- ----------------------------
DROP TABLE IF EXISTS `fa_auth_group_access`;
CREATE TABLE `fa_auth_group_access` (
  `uid` int unsigned NOT NULL COMMENT '会员ID',
  `group_id` int unsigned NOT NULL COMMENT '级别ID',
  UNIQUE KEY `uid_group_id` (`uid`,`group_id`),
  KEY `uid` (`uid`),
  KEY `group_id` (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='权限分组表';

-- ----------------------------
-- Records of fa_auth_group_access
-- ----------------------------
BEGIN;
INSERT INTO `fa_auth_group_access` VALUES (1, 1);
INSERT INTO `fa_auth_group_access` VALUES (2, 4);
COMMIT;

-- ----------------------------
-- Table structure for fa_auth_rule
-- ----------------------------
DROP TABLE IF EXISTS `fa_auth_rule`;
CREATE TABLE `fa_auth_rule` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `type` enum('menu','file') COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'file' COMMENT 'menu为菜单,file为权限节点',
  `pid` int unsigned NOT NULL DEFAULT '0' COMMENT '父ID',
  `name` varchar(100) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '规则名称',
  `title` varchar(50) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '规则名称',
  `icon` varchar(50) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '图标',
  `url` varchar(255) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '规则URL',
  `condition` varchar(255) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '条件',
  `remark` varchar(255) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '备注',
  `ismenu` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '是否为菜单',
  `menutype` enum('addtabs','blank','dialog','ajax') COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '菜单类型',
  `extend` varchar(255) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '扩展属性',
  `py` varchar(30) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '拼音首字母',
  `pinyin` varchar(100) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '拼音',
  `createtime` bigint DEFAULT NULL COMMENT '创建时间',
  `updatetime` bigint DEFAULT NULL COMMENT '更新时间',
  `weigh` int NOT NULL DEFAULT '0' COMMENT '权重',
  `status` varchar(30) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '状态',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`) USING BTREE,
  KEY `pid` (`pid`),
  KEY `weigh` (`weigh`)
) ENGINE=InnoDB AUTO_INCREMENT=120 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='节点表';

-- ----------------------------
-- Records of fa_auth_rule
-- ----------------------------
BEGIN;
INSERT INTO `fa_auth_rule` VALUES (1, 'file', 0, 'dashboard', 'Dashboard', 'fa fa-dashboard', '', '', 'Dashboard tips', 1, NULL, '', 'kzt', 'kongzhitai', 1491635035, 1491635035, 143, 'normal');
INSERT INTO `fa_auth_rule` VALUES (2, 'file', 0, 'general', 'General', 'fa fa-cogs', '', '', '', 1, NULL, '', 'cggl', 'changguiguanli', 1491635035, 1491635035, 137, 'normal');
INSERT INTO `fa_auth_rule` VALUES (3, 'file', 0, 'category', 'Category', 'fa fa-leaf', '', '', 'Category tips', 0, NULL, '', 'flgl', 'fenleiguanli', 1491635035, 1491635035, 119, 'normal');
INSERT INTO `fa_auth_rule` VALUES (4, 'file', 0, 'addon', 'Addon', 'fa fa-rocket', '', '', 'Addon tips', 1, NULL, '', 'cjgl', 'chajianguanli', 1491635035, 1733207012, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (5, 'file', 0, 'auth', 'Auth', 'fa fa-group', '', '', '', 1, NULL, '', 'qxgl', 'quanxianguanli', 1491635035, 1491635035, 99, 'normal');
INSERT INTO `fa_auth_rule` VALUES (6, 'file', 2, 'general/config', 'Config', 'fa fa-cog', '', '', 'Config tips', 1, NULL, '', 'xtpz', 'xitongpeizhi', 1491635035, 1491635035, 60, 'normal');
INSERT INTO `fa_auth_rule` VALUES (7, 'file', 2, 'general/attachment', 'Attachment', 'fa fa-file-image-o', '', '', 'Attachment tips', 1, NULL, '', 'fjgl', 'fujianguanli', 1491635035, 1491635035, 53, 'normal');
INSERT INTO `fa_auth_rule` VALUES (8, 'file', 2, 'general/profile', 'Profile', 'fa fa-user', '', '', '', 1, NULL, '', 'grzl', 'gerenziliao', 1491635035, 1491635035, 34, 'normal');
INSERT INTO `fa_auth_rule` VALUES (9, 'file', 5, 'auth/admin', 'Admin', 'fa fa-user', '', '', 'Admin tips', 1, NULL, '', 'glygl', 'guanliyuanguanli', 1491635035, 1491635035, 118, 'normal');
INSERT INTO `fa_auth_rule` VALUES (10, 'file', 5, 'auth/adminlog', 'Admin log', 'fa fa-list-alt', '', '', 'Admin log tips', 1, NULL, '', 'glyrz', 'guanliyuanrizhi', 1491635035, 1491635035, 113, 'normal');
INSERT INTO `fa_auth_rule` VALUES (11, 'file', 5, 'auth/group', 'Group', 'fa fa-group', '', '', 'Group tips', 1, NULL, '', 'jsz', 'juesezu', 1491635035, 1491635035, 109, 'normal');
INSERT INTO `fa_auth_rule` VALUES (12, 'file', 5, 'auth/rule', 'Rule', 'fa fa-bars', '', '', 'Rule tips', 1, NULL, '', 'cdgz', 'caidanguize', 1491635035, 1491635035, 104, 'normal');
INSERT INTO `fa_auth_rule` VALUES (13, 'file', 1, 'dashboard/index', 'View', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 136, 'normal');
INSERT INTO `fa_auth_rule` VALUES (14, 'file', 1, 'dashboard/add', 'Add', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 135, 'normal');
INSERT INTO `fa_auth_rule` VALUES (15, 'file', 1, 'dashboard/del', 'Delete', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 133, 'normal');
INSERT INTO `fa_auth_rule` VALUES (16, 'file', 1, 'dashboard/edit', 'Edit', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 134, 'normal');
INSERT INTO `fa_auth_rule` VALUES (17, 'file', 1, 'dashboard/multi', 'Multi', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 132, 'normal');
INSERT INTO `fa_auth_rule` VALUES (18, 'file', 6, 'general/config/index', 'View', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 52, 'normal');
INSERT INTO `fa_auth_rule` VALUES (19, 'file', 6, 'general/config/add', 'Add', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 51, 'normal');
INSERT INTO `fa_auth_rule` VALUES (20, 'file', 6, 'general/config/edit', 'Edit', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 50, 'normal');
INSERT INTO `fa_auth_rule` VALUES (21, 'file', 6, 'general/config/del', 'Delete', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 49, 'normal');
INSERT INTO `fa_auth_rule` VALUES (22, 'file', 6, 'general/config/multi', 'Multi', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 48, 'normal');
INSERT INTO `fa_auth_rule` VALUES (23, 'file', 7, 'general/attachment/index', 'View', 'fa fa-circle-o', '', '', 'Attachment tips', 0, NULL, '', '', '', 1491635035, 1491635035, 59, 'normal');
INSERT INTO `fa_auth_rule` VALUES (24, 'file', 7, 'general/attachment/select', 'Select attachment', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 58, 'normal');
INSERT INTO `fa_auth_rule` VALUES (25, 'file', 7, 'general/attachment/add', 'Add', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 57, 'normal');
INSERT INTO `fa_auth_rule` VALUES (26, 'file', 7, 'general/attachment/edit', 'Edit', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 56, 'normal');
INSERT INTO `fa_auth_rule` VALUES (27, 'file', 7, 'general/attachment/del', 'Delete', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 55, 'normal');
INSERT INTO `fa_auth_rule` VALUES (28, 'file', 7, 'general/attachment/multi', 'Multi', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 54, 'normal');
INSERT INTO `fa_auth_rule` VALUES (29, 'file', 8, 'general/profile/index', 'View', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 33, 'normal');
INSERT INTO `fa_auth_rule` VALUES (30, 'file', 8, 'general/profile/update', 'Update profile', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 32, 'normal');
INSERT INTO `fa_auth_rule` VALUES (31, 'file', 8, 'general/profile/add', 'Add', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 31, 'normal');
INSERT INTO `fa_auth_rule` VALUES (32, 'file', 8, 'general/profile/edit', 'Edit', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 30, 'normal');
INSERT INTO `fa_auth_rule` VALUES (33, 'file', 8, 'general/profile/del', 'Delete', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 29, 'normal');
INSERT INTO `fa_auth_rule` VALUES (34, 'file', 8, 'general/profile/multi', 'Multi', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 28, 'normal');
INSERT INTO `fa_auth_rule` VALUES (35, 'file', 3, 'category/index', 'View', 'fa fa-circle-o', '', '', 'Category tips', 0, NULL, '', '', '', 1491635035, 1491635035, 142, 'normal');
INSERT INTO `fa_auth_rule` VALUES (36, 'file', 3, 'category/add', 'Add', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 141, 'normal');
INSERT INTO `fa_auth_rule` VALUES (37, 'file', 3, 'category/edit', 'Edit', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 140, 'normal');
INSERT INTO `fa_auth_rule` VALUES (38, 'file', 3, 'category/del', 'Delete', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 139, 'normal');
INSERT INTO `fa_auth_rule` VALUES (39, 'file', 3, 'category/multi', 'Multi', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 138, 'normal');
INSERT INTO `fa_auth_rule` VALUES (40, 'file', 9, 'auth/admin/index', 'View', 'fa fa-circle-o', '', '', 'Admin tips', 0, NULL, '', '', '', 1491635035, 1491635035, 117, 'normal');
INSERT INTO `fa_auth_rule` VALUES (41, 'file', 9, 'auth/admin/add', 'Add', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 116, 'normal');
INSERT INTO `fa_auth_rule` VALUES (42, 'file', 9, 'auth/admin/edit', 'Edit', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 115, 'normal');
INSERT INTO `fa_auth_rule` VALUES (43, 'file', 9, 'auth/admin/del', 'Delete', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 114, 'normal');
INSERT INTO `fa_auth_rule` VALUES (44, 'file', 10, 'auth/adminlog/index', 'View', 'fa fa-circle-o', '', '', 'Admin log tips', 0, NULL, '', '', '', 1491635035, 1491635035, 112, 'normal');
INSERT INTO `fa_auth_rule` VALUES (45, 'file', 10, 'auth/adminlog/detail', 'Detail', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 111, 'normal');
INSERT INTO `fa_auth_rule` VALUES (46, 'file', 10, 'auth/adminlog/del', 'Delete', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 110, 'normal');
INSERT INTO `fa_auth_rule` VALUES (47, 'file', 11, 'auth/group/index', 'View', 'fa fa-circle-o', '', '', 'Group tips', 0, NULL, '', '', '', 1491635035, 1491635035, 108, 'normal');
INSERT INTO `fa_auth_rule` VALUES (48, 'file', 11, 'auth/group/add', 'Add', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 107, 'normal');
INSERT INTO `fa_auth_rule` VALUES (49, 'file', 11, 'auth/group/edit', 'Edit', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 106, 'normal');
INSERT INTO `fa_auth_rule` VALUES (50, 'file', 11, 'auth/group/del', 'Delete', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 105, 'normal');
INSERT INTO `fa_auth_rule` VALUES (51, 'file', 12, 'auth/rule/index', 'View', 'fa fa-circle-o', '', '', 'Rule tips', 0, NULL, '', '', '', 1491635035, 1491635035, 103, 'normal');
INSERT INTO `fa_auth_rule` VALUES (52, 'file', 12, 'auth/rule/add', 'Add', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 102, 'normal');
INSERT INTO `fa_auth_rule` VALUES (53, 'file', 12, 'auth/rule/edit', 'Edit', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 101, 'normal');
INSERT INTO `fa_auth_rule` VALUES (54, 'file', 12, 'auth/rule/del', 'Delete', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 100, 'normal');
INSERT INTO `fa_auth_rule` VALUES (55, 'file', 4, 'addon/index', 'View', 'fa fa-circle-o', '', '', 'Addon tips', 0, NULL, '', '', '', 1491635035, 1491635035, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (56, 'file', 4, 'addon/add', 'Add', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (57, 'file', 4, 'addon/edit', 'Edit', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (58, 'file', 4, 'addon/del', 'Delete', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (59, 'file', 4, 'addon/downloaded', 'Local addon', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (60, 'file', 4, 'addon/state', 'Update state', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (63, 'file', 4, 'addon/config', 'Setting', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (64, 'file', 4, 'addon/refresh', 'Refresh', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (65, 'file', 4, 'addon/multi', 'Multi', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (85, 'file', 0, 'command', '在线命令管理', 'fa fa-terminal', '', '', '', 1, NULL, '', 'zxmlgl', 'zaixianminglingguanli', 1732173485, 1733225864, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (86, 'file', 85, 'command/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'zk', 'zhakan', 1732173485, 1732173485, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (87, 'file', 85, 'command/add', '添加', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'tj', 'tianjia', 1732173485, 1732173485, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (88, 'file', 85, 'command/detail', '详情', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'xq', 'xiangqing', 1732173485, 1732173485, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (89, 'file', 85, 'command/command', '生成并执行命令', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'scbzxml', 'shengchengbingzhixingmingling', 1732173485, 1732173485, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (90, 'file', 85, 'command/execute', '再次执行命令', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'zczxml', 'zaicizhixingmingling', 1732173485, 1732173485, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (91, 'file', 85, 'command/del', '删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'sc', 'shanchu', 1732173485, 1732173485, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (92, 'file', 85, 'command/multi', '批量更新', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'plgx', 'pilianggengxin', 1732173485, 1732173485, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (93, 'file', 0, 'company', '公司管理', 'fa fa-circle-o', '', '', '', 1, NULL, '', 'gsgl', 'gongsiguanli', 1732173905, 1732173905, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (94, 'file', 93, 'company/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'zk', 'zhakan', 1732173905, 1732173905, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (95, 'file', 93, 'company/recyclebin', '回收站', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'hsz', 'huishouzhan', 1732173905, 1732173905, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (96, 'file', 93, 'company/add', '添加', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'tj', 'tianjia', 1732173905, 1732173905, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (97, 'file', 93, 'company/edit', '编辑', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'bj', 'bianji', 1732173905, 1732173905, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (98, 'file', 93, 'company/del', '删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'sc', 'shanchu', 1732173905, 1732173905, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (99, 'file', 93, 'company/destroy', '真实删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'zssc', 'zhenshishanchu', 1732173905, 1732173905, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (100, 'file', 93, 'company/restore', '还原', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'hy', 'huanyuan', 1732173905, 1732173905, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (101, 'file', 93, 'company/multi', '批量更新', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'plgx', 'pilianggengxin', 1732173905, 1732173905, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (102, 'file', 0, 'staff', '员工管理', 'fa fa-circle-o', '', '', '', 1, NULL, '', 'yggl', 'yuangongguanli', 1732175934, 1732175934, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (103, 'file', 102, 'staff/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'zk', 'zhakan', 1732175934, 1733225914, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (104, 'file', 102, 'staff/recyclebin', '回收站', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'hsz', 'huishouzhan', 1732175934, 1733225914, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (105, 'file', 102, 'staff/add', '添加', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'tj', 'tianjia', 1732175934, 1733225914, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (106, 'file', 102, 'staff/edit', '编辑', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'bj', 'bianji', 1732175934, 1733225914, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (107, 'file', 102, 'staff/del', '删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'sc', 'shanchu', 1732175934, 1733225914, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (108, 'file', 102, 'staff/destroy', '真实删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'zssc', 'zhenshishanchu', 1732175934, 1733225914, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (109, 'file', 102, 'staff/restore', '还原', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'hy', 'huanyuan', 1732175934, 1733225914, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (110, 'file', 102, 'staff/multi', '批量更新', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'plgx', 'pilianggengxin', 1732175934, 1733225914, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (111, 'file', 0, 'salary', '工资管理', 'fa fa-circle-o', '', '', '', 1, NULL, '', 'gzgl', 'gongziguanli', 1732785006, 1732785006, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (112, 'file', 111, 'salary/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'zk', 'zhakan', 1732785006, 1732786287, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (113, 'file', 111, 'salary/add', '添加', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'tj', 'tianjia', 1732785006, 1732786287, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (114, 'file', 111, 'salary/edit', '编辑', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'bj', 'bianji', 1732785006, 1732786287, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (115, 'file', 111, 'salary/del', '删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'sc', 'shanchu', 1732785006, 1732786287, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (116, 'file', 111, 'salary/multi', '批量更新', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'plgx', 'pilianggengxin', 1732785006, 1732786287, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (117, 'file', 111, 'salary/recyclebin', '回收站', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'hsz', 'huishouzhan', 1732786287, 1732786287, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (118, 'file', 111, 'salary/destroy', '真实删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'zssc', 'zhenshishanchu', 1732786287, 1732786287, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (119, 'file', 111, 'salary/restore', '还原', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'hy', 'huanyuan', 1732786287, 1732786287, 0, 'normal');
COMMIT;

-- ----------------------------
-- Table structure for fa_category
-- ----------------------------
DROP TABLE IF EXISTS `fa_category`;
CREATE TABLE `fa_category` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `pid` int unsigned NOT NULL DEFAULT '0' COMMENT '父ID',
  `type` varchar(30) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '栏目类型',
  `name` varchar(30) COLLATE utf8mb4_general_ci DEFAULT '',
  `nickname` varchar(50) COLLATE utf8mb4_general_ci DEFAULT '',
  `flag` set('hot','index','recommend') COLLATE utf8mb4_general_ci DEFAULT '',
  `image` varchar(100) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '图片',
  `keywords` varchar(255) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '关键字',
  `description` varchar(255) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '描述',
  `diyname` varchar(30) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '自定义名称',
  `createtime` bigint DEFAULT NULL COMMENT '创建时间',
  `updatetime` bigint DEFAULT NULL COMMENT '更新时间',
  `weigh` int NOT NULL DEFAULT '0' COMMENT '权重',
  `status` varchar(30) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '状态',
  PRIMARY KEY (`id`),
  KEY `weigh` (`weigh`,`id`),
  KEY `pid` (`pid`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='分类表';

-- ----------------------------
-- Records of fa_category
-- ----------------------------
BEGIN;
INSERT INTO `fa_category` VALUES (1, 0, 'page', '官方新闻', 'news', 'recommend', '/assets/img/qrcode.png', '', '', 'news', 1491635035, 1491635035, 1, 'normal');
INSERT INTO `fa_category` VALUES (2, 0, 'page', '移动应用', 'mobileapp', 'hot', '/assets/img/qrcode.png', '', '', 'mobileapp', 1491635035, 1491635035, 2, 'normal');
INSERT INTO `fa_category` VALUES (3, 2, 'page', '微信公众号', 'wechatpublic', 'index', '/assets/img/qrcode.png', '', '', 'wechatpublic', 1491635035, 1491635035, 3, 'normal');
INSERT INTO `fa_category` VALUES (4, 2, 'page', 'Android开发', 'android', 'recommend', '/assets/img/qrcode.png', '', '', 'android', 1491635035, 1491635035, 4, 'normal');
INSERT INTO `fa_category` VALUES (5, 0, 'page', '软件产品', 'software', 'recommend', '/assets/img/qrcode.png', '', '', 'software', 1491635035, 1491635035, 5, 'normal');
INSERT INTO `fa_category` VALUES (6, 5, 'page', '网站建站', 'website', 'recommend', '/assets/img/qrcode.png', '', '', 'website', 1491635035, 1491635035, 6, 'normal');
INSERT INTO `fa_category` VALUES (7, 5, 'page', '企业管理软件', 'company', 'index', '/assets/img/qrcode.png', '', '', 'company', 1491635035, 1491635035, 7, 'normal');
INSERT INTO `fa_category` VALUES (8, 6, 'page', 'PC端', 'website-pc', 'recommend', '/assets/img/qrcode.png', '', '', 'website-pc', 1491635035, 1491635035, 8, 'normal');
INSERT INTO `fa_category` VALUES (9, 6, 'page', '移动端', 'website-mobile', 'recommend', '/assets/img/qrcode.png', '', '', 'website-mobile', 1491635035, 1491635035, 9, 'normal');
INSERT INTO `fa_category` VALUES (10, 7, 'page', 'CRM系统 ', 'company-crm', 'recommend', '/assets/img/qrcode.png', '', '', 'company-crm', 1491635035, 1491635035, 10, 'normal');
INSERT INTO `fa_category` VALUES (11, 7, 'page', 'SASS平台软件', 'company-sass', 'recommend', '/assets/img/qrcode.png', '', '', 'company-sass', 1491635035, 1491635035, 11, 'normal');
INSERT INTO `fa_category` VALUES (12, 0, 'test', '测试1', 'test1', 'recommend', '/assets/img/qrcode.png', '', '', 'test1', 1491635035, 1491635035, 12, 'normal');
INSERT INTO `fa_category` VALUES (13, 0, 'test', '测试2', 'test2', 'recommend', '/assets/img/qrcode.png', '', '', 'test2', 1491635035, 1491635035, 13, 'normal');
COMMIT;

-- ----------------------------
-- Table structure for fa_command
-- ----------------------------
DROP TABLE IF EXISTS `fa_command`;
CREATE TABLE `fa_command` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `type` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '类型',
  `params` varchar(1500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '参数',
  `command` varchar(1500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '命令',
  `content` text COMMENT '返回结果',
  `executetime` bigint unsigned DEFAULT NULL COMMENT '执行时间',
  `createtime` bigint unsigned DEFAULT NULL COMMENT '创建时间',
  `updatetime` bigint unsigned DEFAULT NULL COMMENT '更新时间',
  `status` enum('successed','failured') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'failured' COMMENT '状态',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb3 COMMENT='在线命令表';

-- ----------------------------
-- Records of fa_command
-- ----------------------------
BEGIN;
INSERT INTO `fa_command` VALUES (1, 'crud', '[\"--table=fa_company\"]', 'php think crud --table=fa_company', 'Build Successed', 1732173892, 1732173892, 1732173892, 'successed');
INSERT INTO `fa_command` VALUES (2, 'menu', '[\"--controller=Company\"]', 'php think menu --controller=Company', 'Build Successed!', 1732173905, 1732173905, 1732173905, 'successed');
INSERT INTO `fa_command` VALUES (3, 'crud', '[\"--table=fa_staff\"]', 'php think crud --table=fa_staff', 'Build Successed', 1732175923, 1732175923, 1732175923, 'successed');
INSERT INTO `fa_command` VALUES (4, 'menu', '[\"--controller=Staff\"]', 'php think menu --controller=Staff', 'Build Successed!', 1732175934, 1732175934, 1732175934, 'successed');
INSERT INTO `fa_command` VALUES (5, 'crud', '[\"--force=1\",\"--table=fa_staff\"]', 'php think crud --force=1 --table=fa_staff', 'Build Successed', 1732262055, 1732262055, 1732262055, 'successed');
INSERT INTO `fa_command` VALUES (6, 'crud', '[\"--table=fa_salary\"]', 'php think crud --table=fa_salary', 'Build Successed', 1732784989, 1732784989, 1732784989, 'successed');
INSERT INTO `fa_command` VALUES (7, 'menu', '[\"--controller=Salary\"]', 'php think menu --controller=Salary', 'Build Successed!', 1732785005, 1732785005, 1732785006, 'successed');
INSERT INTO `fa_command` VALUES (8, 'crud', '[\"--force=1\",\"--table=fa_salary\"]', 'php think crud --force=1 --table=fa_salary', 'Build Successed', 1732786272, 1732786272, 1732786272, 'successed');
INSERT INTO `fa_command` VALUES (9, 'menu', '[\"--force=1\",\"--controller=Salary\"]', 'php think menu --force=1 --controller=Salary', 'Build Successed!', 1732786287, 1732786287, 1732786287, 'successed');
INSERT INTO `fa_command` VALUES (10, 'crud', '[\"--table=fa_msglog\"]', 'php think crud --table=fa_msglog', 'Build Successed', 1733124546, 1733124546, 1733124546, 'successed');
INSERT INTO `fa_command` VALUES (11, 'crud', '[\"--force=1\",\"--table=fa_msglog\"]', 'php think crud --force=1 --table=fa_msglog', 'Build Successed', 1733127309, 1733127309, 1733127309, 'successed');
INSERT INTO `fa_command` VALUES (12, 'crud', '[\"--force=1\",\"--table=fa_staff\"]', 'php think crud --force=1 --table=fa_staff', 'Build Successed', 1733225885, 1733225885, 1733225885, 'successed');
INSERT INTO `fa_command` VALUES (13, 'menu', '[\"--controller=Staff\"]', 'php think menu --controller=Staff', 'Build Successed!', 1733225914, 1733225914, 1733225914, 'successed');
INSERT INTO `fa_command` VALUES (14, 'crud', '[\"--force=1\",\"--table=fa_staff\"]', 'php think crud --force=1 --table=fa_staff', 'Build Successed', 1733226013, 1733226013, 1733226013, 'successed');
INSERT INTO `fa_command` VALUES (15, 'crud', '[\"--force=1\",\"--table=fa_staff\"]', 'php think crud --force=1 --table=fa_staff', 'Build Successed', 1733230290, 1733230290, 1733230290, 'successed');
INSERT INTO `fa_command` VALUES (16, 'crud', '[\"--table=fa_contract_record\"]', 'php think crud --table=fa_contract_record', 'Build Successed', 1733453805, 1733453805, 1733453805, 'successed');
COMMIT;

-- ----------------------------
-- Table structure for fa_company
-- ----------------------------
DROP TABLE IF EXISTS `fa_company`;
CREATE TABLE `fa_company` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '公司名称',
  `createtime` bigint DEFAULT NULL COMMENT '创建时间',
  `updatetime` bigint DEFAULT NULL COMMENT '更新时间',
  `deletetime` bigint DEFAULT NULL COMMENT '删除时间',
  `weigh` int DEFAULT '0' COMMENT '权重',
  `secretId` varchar(100) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '调用API的secretId，通过腾讯云控制台获取',
  `secretKey` varchar(100) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '调用API的secretKey，通过腾讯云控制台获取',
  `operatorUserId` varchar(100) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '经办人Id，电子签控制台获取',
  `serverSignSealId` varchar(100) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '企业方静默签用的印章Id，电子签控制台获取',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='公司表';

-- ----------------------------
-- Records of fa_company
-- ----------------------------
BEGIN;
INSERT INTO `fa_company` VALUES (1, '阿里巴巴', 1732173920, 1740728310, 1740728310, 1, '', '', '', '');
INSERT INTO `fa_company` VALUES (2, '腾讯', 1732173923, 1740728312, 1740728312, 2, '', '', '', '');
INSERT INTO `fa_company` VALUES (3, '上海申瑞人力资源有限公司', 1740728321, 1741595441, NULL, 3, '', '', 'yDCdcUU53cznh4UEXKV7d8fT5LXyaXeg', 'yDCdcUU5kdd02vUudgixHJvCvLhqBD2C');
INSERT INTO `fa_company` VALUES (4, '安徽酷驰人力资源有限公司', 1740728330, 1741595448, NULL, 4, '', '', 'yDCdcUU53cznh4UEXKV7d8fT5LXyaXeg', 'yDCdnUU5ojca0rUy0HJMrRx07Blzgmh4');
INSERT INTO `fa_company` VALUES (5, '江西省申瑞人力资源有限公司', 1740728336, 1741595451, NULL, 5, '', '', '33', '44');
COMMIT;

-- ----------------------------
-- Table structure for fa_config
-- ----------------------------
DROP TABLE IF EXISTS `fa_config`;
CREATE TABLE `fa_config` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(30) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '变量名',
  `group` varchar(30) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '分组',
  `title` varchar(100) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '变量标题',
  `tip` varchar(100) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '变量描述',
  `type` varchar(30) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '类型:string,text,int,bool,array,datetime,date,file',
  `visible` varchar(255) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '可见条件',
  `value` text COLLATE utf8mb4_general_ci COMMENT '变量值',
  `content` text COLLATE utf8mb4_general_ci COMMENT '变量字典数据',
  `rule` varchar(100) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '验证规则',
  `extend` varchar(255) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '扩展属性',
  `setting` varchar(255) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '配置',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='系统配置';

-- ----------------------------
-- Records of fa_config
-- ----------------------------
BEGIN;
INSERT INTO `fa_config` VALUES (1, 'name', 'basic', 'Site name', '请填写站点名称', 'string', '', '工资查询系统', '', 'required', '', '');
INSERT INTO `fa_config` VALUES (2, 'beian', 'basic', 'Beian', '粤ICP备15000000号-1', 'string', '', '', '', '', '', '');
INSERT INTO `fa_config` VALUES (3, 'cdnurl', 'basic', 'Cdn url', '如果全站静态资源使用第三方云储存请配置该值', 'string', '', '', '', '', '', '');
INSERT INTO `fa_config` VALUES (4, 'version', 'basic', 'Version', '如果静态资源有变动请重新配置该值', 'string', '', '1.0.3', '', 'required', '', '');
INSERT INTO `fa_config` VALUES (5, 'timezone', 'basic', 'Timezone', '', 'string', '', 'Asia/Shanghai', '', 'required', '', '');
INSERT INTO `fa_config` VALUES (6, 'forbiddenip', 'basic', 'Forbidden ip', '一行一条记录', 'text', '', '', '', '', '', '');
INSERT INTO `fa_config` VALUES (7, 'languages', 'basic', 'Languages', '', 'array', '', '{\"backend\":\"zh-cn\",\"frontend\":\"zh-cn\"}', '', 'required', '', '');
INSERT INTO `fa_config` VALUES (8, 'fixedpage', 'basic', 'Fixed page', '请输入左侧菜单栏存在的链接', 'string', '', 'dashboard', '', 'required', '', '');
INSERT INTO `fa_config` VALUES (9, 'categorytype', 'dictionary', 'Category type', '', 'array', '', '{\"default\":\"Default\",\"page\":\"Page\",\"article\":\"Article\",\"test\":\"Test\"}', '', '', '', '');
INSERT INTO `fa_config` VALUES (10, 'configgroup', 'dictionary', 'Config group', '', 'array', '', '{\"basic\":\"Basic\",\"email\":\"Email\",\"dictionary\":\"Dictionary\",\"user\":\"User\",\"example\":\"Example\"}', '', '', '', '');
INSERT INTO `fa_config` VALUES (11, 'mail_type', 'email', 'Mail type', '选择邮件发送方式', 'select', '', '1', '[\"请选择\",\"SMTP\"]', '', '', '');
INSERT INTO `fa_config` VALUES (12, 'mail_smtp_host', 'email', 'Mail smtp host', '错误的配置发送邮件会导致服务器超时', 'string', '', 'smtp.qq.com', '', '', '', '');
INSERT INTO `fa_config` VALUES (13, 'mail_smtp_port', 'email', 'Mail smtp port', '(不加密默认25,SSL默认465,TLS默认587)', 'string', '', '465', '', '', '', '');
INSERT INTO `fa_config` VALUES (14, 'mail_smtp_user', 'email', 'Mail smtp user', '（填写完整用户名）', 'string', '', '', '', '', '', '');
INSERT INTO `fa_config` VALUES (15, 'mail_smtp_pass', 'email', 'Mail smtp password', '（填写您的密码或授权码）', 'password', '', '', '', '', '', '');
INSERT INTO `fa_config` VALUES (16, 'mail_verify_type', 'email', 'Mail vertify type', '（SMTP验证方式[推荐SSL]）', 'select', '', '2', '[\"无\",\"TLS\",\"SSL\"]', '', '', '');
INSERT INTO `fa_config` VALUES (17, 'mail_from', 'email', 'Mail from', '', 'string', '', '', '', '', '', '');
INSERT INTO `fa_config` VALUES (18, 'attachmentcategory', 'dictionary', 'Attachment category', '', 'array', '', '{\"category1\":\"Category1\",\"category2\":\"Category2\",\"custom\":\"Custom\"}', '', '', '', '');
COMMIT;

-- ----------------------------
-- Table structure for fa_contract_record
-- ----------------------------
DROP TABLE IF EXISTS `fa_contract_record`;
CREATE TABLE `fa_contract_record` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `staff_id` int unsigned NOT NULL DEFAULT '0' COMMENT '员工id',
  `flowid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '合同流id',
  `flowinfo` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '合同信息',
  `contract_status` enum('0','1','2','3','4','5','6','7','8','9','10','21') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '合同状态:0=未开启流程,1=待签署,2=部分签署,3=已拒签,4=已签署,5=已过期,6=已撤销,7=未开启流程(合同中存在填写环节),8=等待填写,9=部分填写,10=已拒填,21=已解除',
  `createtime` bigint DEFAULT NULL COMMENT '创建时间',
  `updatetime` bigint DEFAULT NULL COMMENT '更新时间',
  `templateId` varchar(100) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '合同模版id',
  PRIMARY KEY (`id`),
  KEY `staff_id` (`staff_id`),
  KEY `flowid` (`flowid`),
  KEY `contract_status` (`contract_status`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='合同记录';

-- ----------------------------
-- Records of fa_contract_record
-- ----------------------------
BEGIN;
INSERT INTO `fa_contract_record` VALUES (1, 1, 'yDCYuUU5wyfj20Uus4BJXv65r02sBnts', 'O:48:\"TencentCloud\\Ess\\V20201111\\Models\\FlowDetailInfo\":10:{s:6:\"FlowId\";s:32:\"yDCYuUU5wyfj20Uus4BJXv65r02sBnts\";s:8:\"FlowName\";s:21:\"张三的劳动合同\";s:8:\"FlowType\";s:0:\"\";s:10:\"FlowStatus\";i:6;s:11:\"FlowMessage\";s:140:\"发起方-上海申瑞人力资源有限公司以“工资查询系统后台-管理员手动撤销电子合同”的理由撤销当前合同\";s:15:\"FlowDescription\";s:0:\"\";s:9:\"CreatedOn\";i:1733464858;s:17:\"FlowApproverInfos\";a:2:{i:0;O:52:\"TencentCloud\\Ess\\V20201111\\Models\\FlowApproverDetail\":15:{s:14:\"ApproveMessage\";s:0:\"\";s:11:\"ApproveName\";s:9:\"张生龙\";s:13:\"ApproveStatus\";i:3;s:9:\"ReceiptId\";s:32:\"yDCYyUU5vuh477UEqnHxWuutmWjpBICi\";s:12:\"CustomUserId\";s:0:\"\";s:6:\"Mobile\";s:11:\"18201786888\";s:9:\"SignOrder\";i:0;s:11:\"ApproveTime\";i:1733464861;s:11:\"ApproveType\";s:16:\"ENTERPRISESERVER\";s:14:\"ApproverSource\";s:0:\"\";s:17:\"CustomApproverTag\";s:0:\"\";s:14:\"OrganizationId\";s:32:\"yDCdcUU53c9c88UE3LRjhx0RHDA2NF4n\";s:16:\"OrganizationName\";s:36:\"上海申瑞人力资源有限公司\";s:6:\"SignId\";s:32:\"yDCYuUU5wyfj2pUus4BJXu3FwcWDmaNW\";s:16:\"ApproverRoleName\";s:36:\"上海申瑞人力资源有限公司\";}i:1;O:52:\"TencentCloud\\Ess\\V20201111\\Models\\FlowApproverDetail\":15:{s:14:\"ApproveMessage\";s:140:\"发起方-上海申瑞人力资源有限公司以“工资查询系统后台-管理员手动撤销电子合同”的理由撤销当前合同\";s:11:\"ApproveName\";s:6:\"张三\";s:13:\"ApproveStatus\";i:9;s:9:\"ReceiptId\";s:32:\"yDCYyUU5vuh474UEqnHxWviSF14Kjx8M\";s:12:\"CustomUserId\";s:0:\"\";s:6:\"Mobile\";s:11:\"17086263668\";s:9:\"SignOrder\";i:1;s:11:\"ApproveTime\";i:0;s:11:\"ApproveType\";s:6:\"PERSON\";s:14:\"ApproverSource\";s:0:\"\";s:17:\"CustomApproverTag\";s:0:\"\";s:14:\"OrganizationId\";s:0:\"\";s:16:\"OrganizationName\";s:0:\"\";s:6:\"SignId\";s:32:\"yDCYuUU5wyfj2nUus4BJXwANJWVslYb8\";s:16:\"ApproverRoleName\";s:6:\"乙方\";}}s:7:\"CcInfos\";a:0:{}s:7:\"Creator\";s:32:\"yDCdcUU53cznh4UEXKV7d8fT5LXyaXeg\";}', '6', 1733464861, 1741858020, '');
INSERT INTO `fa_contract_record` VALUES (2, 1, 'yDtCsUUl7d9xpkUylhbd4vekeSdXTpjD', 'O:48:\"TencentCloud\\Ess\\V20201111\\Models\\FlowDetailInfo\":10:{s:6:\"FlowId\";s:32:\"yDtCsUUl7d9xpkUylhbd4vekeSdXTpjD\";s:8:\"FlowName\";s:21:\"张三的劳动合同\";s:8:\"FlowType\";s:0:\"\";s:10:\"FlowStatus\";i:6;s:11:\"FlowMessage\";s:140:\"发起方-上海申瑞人力资源有限公司以“工资查询系统后台-管理员手动撤销电子合同”的理由撤销当前合同\";s:15:\"FlowDescription\";s:0:\"\";s:9:\"CreatedOn\";i:1741661522;s:17:\"FlowApproverInfos\";a:2:{i:0;O:52:\"TencentCloud\\Ess\\V20201111\\Models\\FlowApproverDetail\":15:{s:14:\"ApproveMessage\";s:0:\"\";s:11:\"ApproveName\";s:9:\"张生龙\";s:13:\"ApproveStatus\";i:3;s:9:\"ReceiptId\";s:32:\"yDCYyUU5vuh477UEqnHxWuutmWjpBICi\";s:12:\"CustomUserId\";s:0:\"\";s:6:\"Mobile\";s:11:\"18201786888\";s:9:\"SignOrder\";i:0;s:11:\"ApproveTime\";i:1741661527;s:11:\"ApproveType\";s:16:\"ENTERPRISESERVER\";s:14:\"ApproverSource\";s:0:\"\";s:17:\"CustomApproverTag\";s:0:\"\";s:14:\"OrganizationId\";s:32:\"yDCdcUU53c9c88UE3LRjhx0RHDA2NF4n\";s:16:\"OrganizationName\";s:36:\"上海申瑞人力资源有限公司\";s:6:\"SignId\";s:32:\"yDtCsUUl7d9xp3Uylhbd4CFC94R8IVP2\";s:16:\"ApproverRoleName\";s:36:\"上海申瑞人力资源有限公司\";}i:1;O:52:\"TencentCloud\\Ess\\V20201111\\Models\\FlowApproverDetail\":15:{s:14:\"ApproveMessage\";s:140:\"发起方-上海申瑞人力资源有限公司以“工资查询系统后台-管理员手动撤销电子合同”的理由撤销当前合同\";s:11:\"ApproveName\";s:6:\"张三\";s:13:\"ApproveStatus\";i:9;s:9:\"ReceiptId\";s:32:\"yDCYyUU5vuh474UEqnHxWviSF14Kjx8M\";s:12:\"CustomUserId\";s:0:\"\";s:6:\"Mobile\";s:11:\"17086263668\";s:9:\"SignOrder\";i:1;s:11:\"ApproveTime\";i:0;s:11:\"ApproveType\";s:6:\"PERSON\";s:14:\"ApproverSource\";s:0:\"\";s:17:\"CustomApproverTag\";s:0:\"\";s:14:\"OrganizationId\";s:0:\"\";s:16:\"OrganizationName\";s:0:\"\";s:6:\"SignId\";s:32:\"yDtCsUUl7d9xp1Uylhbd48hCnq99waC1\";s:16:\"ApproverRoleName\";s:6:\"乙方\";}}s:7:\"CcInfos\";a:0:{}s:7:\"Creator\";s:32:\"yDCdcUU53cznh4UEXKV7d8fT5LXyaXeg\";}', '6', 1741661524, 1741858020, '');
INSERT INTO `fa_contract_record` VALUES (3, 1, 'yDtCrUUl74mggvUEBinyRBA7ayumQD7C', 'O:48:\"TencentCloud\\Ess\\V20201111\\Models\\FlowDetailInfo\":10:{s:6:\"FlowId\";s:32:\"yDtCrUUl74mggvUEBinyRBA7ayumQD7C\";s:8:\"FlowName\";s:21:\"张三的劳动合同\";s:8:\"FlowType\";s:0:\"\";s:10:\"FlowStatus\";i:6;s:11:\"FlowMessage\";s:140:\"发起方-上海申瑞人力资源有限公司以“工资查询系统后台-管理员手动撤销电子合同”的理由撤销当前合同\";s:15:\"FlowDescription\";s:0:\"\";s:9:\"CreatedOn\";i:1741768647;s:17:\"FlowApproverInfos\";a:2:{i:0;O:52:\"TencentCloud\\Ess\\V20201111\\Models\\FlowApproverDetail\":15:{s:14:\"ApproveMessage\";s:0:\"\";s:11:\"ApproveName\";s:9:\"张生龙\";s:13:\"ApproveStatus\";i:3;s:9:\"ReceiptId\";s:32:\"yDtCrUUl741qz6UxkeGyoxS4u5GO84yc\";s:12:\"CustomUserId\";s:0:\"\";s:6:\"Mobile\";s:11:\"18201786888\";s:9:\"SignOrder\";i:0;s:11:\"ApproveTime\";i:1741768651;s:11:\"ApproveType\";s:16:\"ENTERPRISESERVER\";s:14:\"ApproverSource\";s:0:\"\";s:17:\"CustomApproverTag\";s:0:\"\";s:14:\"OrganizationId\";s:32:\"yDCdcUU53c9c88UE3LRjhx0RHDA2NF4n\";s:16:\"OrganizationName\";s:36:\"上海申瑞人力资源有限公司\";s:6:\"SignId\";s:32:\"yDtCrUUl74mggtUEBinyRw2SLh9vP1sC\";s:16:\"ApproverRoleName\";s:36:\"上海申瑞人力资源有限公司\";}i:1;O:52:\"TencentCloud\\Ess\\V20201111\\Models\\FlowApproverDetail\":15:{s:14:\"ApproveMessage\";s:140:\"发起方-上海申瑞人力资源有限公司以“工资查询系统后台-管理员手动撤销电子合同”的理由撤销当前合同\";s:11:\"ApproveName\";s:6:\"张三\";s:13:\"ApproveStatus\";i:9;s:9:\"ReceiptId\";s:32:\"yDtCrUUl741qziUxkeGyouIGnu5H5gx4\";s:12:\"CustomUserId\";s:0:\"\";s:6:\"Mobile\";s:11:\"17685435572\";s:9:\"SignOrder\";i:1;s:11:\"ApproveTime\";i:0;s:11:\"ApproveType\";s:6:\"PERSON\";s:14:\"ApproverSource\";s:0:\"\";s:17:\"CustomApproverTag\";s:0:\"\";s:14:\"OrganizationId\";s:0:\"\";s:16:\"OrganizationName\";s:0:\"\";s:6:\"SignId\";s:32:\"yDtCrUUl74mggoUEBinyRCgC82gO7fn3\";s:16:\"ApproverRoleName\";s:16:\"个人签署方1\";}}s:7:\"CcInfos\";a:0:{}s:7:\"Creator\";s:32:\"yDCdcUU53cznh4UEXKV7d8fT5LXyaXeg\";}', '6', 1741768650, 1741858020, 'yDtCrUUl7b0a19Uui9ulrvxYij2Yhn6j');
INSERT INTO `fa_contract_record` VALUES (4, 1, 'yDtCrUUl74znx8Ux7x1hCup6IfXyHAhp', 'O:48:\"TencentCloud\\Ess\\V20201111\\Models\\FlowDetailInfo\":10:{s:6:\"FlowId\";s:32:\"yDtCrUUl74znx8Ux7x1hCup6IfXyHAhp\";s:8:\"FlowName\";s:24:\"盖庆超的劳动合同\";s:8:\"FlowType\";s:0:\"\";s:10:\"FlowStatus\";i:6;s:11:\"FlowMessage\";s:140:\"发起方-上海申瑞人力资源有限公司以“工资查询系统后台-管理员手动撤销电子合同”的理由撤销当前合同\";s:15:\"FlowDescription\";s:0:\"\";s:9:\"CreatedOn\";i:1741768866;s:17:\"FlowApproverInfos\";a:2:{i:0;O:52:\"TencentCloud\\Ess\\V20201111\\Models\\FlowApproverDetail\":15:{s:14:\"ApproveMessage\";s:0:\"\";s:11:\"ApproveName\";s:9:\"张生龙\";s:13:\"ApproveStatus\";i:3;s:9:\"ReceiptId\";s:32:\"yDtCrUUl741qz6UxkeGyoxS4u5GO84yc\";s:12:\"CustomUserId\";s:0:\"\";s:6:\"Mobile\";s:11:\"18201786888\";s:9:\"SignOrder\";i:0;s:11:\"ApproveTime\";i:1741768870;s:11:\"ApproveType\";s:16:\"ENTERPRISESERVER\";s:14:\"ApproverSource\";s:0:\"\";s:17:\"CustomApproverTag\";s:0:\"\";s:14:\"OrganizationId\";s:32:\"yDCdcUU53c9c88UE3LRjhx0RHDA2NF4n\";s:16:\"OrganizationName\";s:36:\"上海申瑞人力资源有限公司\";s:6:\"SignId\";s:32:\"yDtCrUUl74znxhUx7x1hCR3XMVaA1xLY\";s:16:\"ApproverRoleName\";s:36:\"上海申瑞人力资源有限公司\";}i:1;O:52:\"TencentCloud\\Ess\\V20201111\\Models\\FlowApproverDetail\":15:{s:14:\"ApproveMessage\";s:140:\"发起方-上海申瑞人力资源有限公司以“工资查询系统后台-管理员手动撤销电子合同”的理由撤销当前合同\";s:11:\"ApproveName\";s:9:\"盖庆超\";s:13:\"ApproveStatus\";i:9;s:9:\"ReceiptId\";s:32:\"yDtCrUUl741qziUxkeGyouIGnu5H5gx4\";s:12:\"CustomUserId\";s:0:\"\";s:6:\"Mobile\";s:11:\"17685435572\";s:9:\"SignOrder\";i:1;s:11:\"ApproveTime\";i:0;s:11:\"ApproveType\";s:6:\"PERSON\";s:14:\"ApproverSource\";s:0:\"\";s:17:\"CustomApproverTag\";s:0:\"\";s:14:\"OrganizationId\";s:0:\"\";s:16:\"OrganizationName\";s:0:\"\";s:6:\"SignId\";s:32:\"yDtCrUUl74znx2Ux7x1hC5vmvxxl2egC\";s:16:\"ApproverRoleName\";s:16:\"个人签署方1\";}}s:7:\"CcInfos\";a:0:{}s:7:\"Creator\";s:32:\"yDCdcUU53cznh4UEXKV7d8fT5LXyaXeg\";}', '6', 1741768869, 1741858020, 'yDtCrUUl7b0a19Uui9ulrvxYij2Yhn6j');
INSERT INTO `fa_contract_record` VALUES (5, 1, 'yDtCrUUl74cz5uUEkW4VyEEJgVcc3HvA', 'O:48:\"TencentCloud\\Ess\\V20201111\\Models\\FlowDetailInfo\":10:{s:6:\"FlowId\";s:32:\"yDtCrUUl74cz5uUEkW4VyEEJgVcc3HvA\";s:8:\"FlowName\";s:24:\"盖庆超的劳动合同\";s:8:\"FlowType\";s:0:\"\";s:10:\"FlowStatus\";i:6;s:11:\"FlowMessage\";s:140:\"发起方-上海申瑞人力资源有限公司以“工资查询系统后台-管理员手动撤销电子合同”的理由撤销当前合同\";s:15:\"FlowDescription\";s:0:\"\";s:9:\"CreatedOn\";i:1741769231;s:17:\"FlowApproverInfos\";a:2:{i:0;O:52:\"TencentCloud\\Ess\\V20201111\\Models\\FlowApproverDetail\":15:{s:14:\"ApproveMessage\";s:0:\"\";s:11:\"ApproveName\";s:9:\"张生龙\";s:13:\"ApproveStatus\";i:3;s:9:\"ReceiptId\";s:32:\"yDtCrUUl74c7ahUx7x1hC8Nea5oKWehI\";s:12:\"CustomUserId\";s:0:\"\";s:6:\"Mobile\";s:11:\"18201786888\";s:9:\"SignOrder\";i:0;s:11:\"ApproveTime\";i:1741769235;s:11:\"ApproveType\";s:16:\"ENTERPRISESERVER\";s:14:\"ApproverSource\";s:0:\"\";s:17:\"CustomApproverTag\";s:0:\"\";s:14:\"OrganizationId\";s:32:\"yDCdcUU53c9c88UE3LRjhx0RHDA2NF4n\";s:16:\"OrganizationName\";s:36:\"上海申瑞人力资源有限公司\";s:6:\"SignId\";s:32:\"yDtCrUUl74cz5bUEkW4VyE3Odg3SXG5w\";s:16:\"ApproverRoleName\";s:36:\"上海申瑞人力资源有限公司\";}i:1;O:52:\"TencentCloud\\Ess\\V20201111\\Models\\FlowApproverDetail\":15:{s:14:\"ApproveMessage\";s:140:\"发起方-上海申瑞人力资源有限公司以“工资查询系统后台-管理员手动撤销电子合同”的理由撤销当前合同\";s:11:\"ApproveName\";s:9:\"盖庆超\";s:13:\"ApproveStatus\";i:9;s:9:\"ReceiptId\";s:32:\"yDtCrUUl74c7arUx7x1hCwz74lQBAsVh\";s:12:\"CustomUserId\";s:0:\"\";s:6:\"Mobile\";s:11:\"17685435572\";s:9:\"SignOrder\";i:1;s:11:\"ApproveTime\";i:0;s:11:\"ApproveType\";s:6:\"PERSON\";s:14:\"ApproverSource\";s:0:\"\";s:17:\"CustomApproverTag\";s:0:\"\";s:14:\"OrganizationId\";s:0:\"\";s:16:\"OrganizationName\";s:0:\"\";s:6:\"SignId\";s:32:\"yDtCrUUl74cz5aUEkW4VyyF0HgsMHbEZ\";s:16:\"ApproverRoleName\";s:16:\"个人签署方1\";}}s:7:\"CcInfos\";a:0:{}s:7:\"Creator\";s:32:\"yDCdcUU53cznh4UEXKV7d8fT5LXyaXeg\";}', '6', 1741769234, 1741858020, 'yDtCrUUl7b0a19Uui9ulrvxYij2Yhn6j');
INSERT INTO `fa_contract_record` VALUES (6, 1, 'yDtCrUUl77p6hgUyB0wakxxQCskDAF59', 'O:48:\"TencentCloud\\Ess\\V20201111\\Models\\FlowDetailInfo\":10:{s:6:\"FlowId\";s:32:\"yDtCrUUl77p6hgUyB0wakxxQCskDAF59\";s:8:\"FlowName\";s:24:\"盖庆超的劳动合同\";s:8:\"FlowType\";s:0:\"\";s:10:\"FlowStatus\";i:6;s:11:\"FlowMessage\";s:140:\"发起方-上海申瑞人力资源有限公司以“工资查询系统后台-管理员手动撤销电子合同”的理由撤销当前合同\";s:15:\"FlowDescription\";s:0:\"\";s:9:\"CreatedOn\";i:1741769364;s:17:\"FlowApproverInfos\";a:2:{i:0;O:52:\"TencentCloud\\Ess\\V20201111\\Models\\FlowApproverDetail\":15:{s:14:\"ApproveMessage\";s:0:\"\";s:11:\"ApproveName\";s:9:\"张生龙\";s:13:\"ApproveStatus\";i:3;s:9:\"ReceiptId\";s:32:\"yDtCrUUl77gdwgUupriJV8d1zDZQJqdG\";s:12:\"CustomUserId\";s:0:\"\";s:6:\"Mobile\";s:11:\"18201786888\";s:9:\"SignOrder\";i:0;s:11:\"ApproveTime\";i:1741769368;s:11:\"ApproveType\";s:16:\"ENTERPRISESERVER\";s:14:\"ApproverSource\";s:0:\"\";s:17:\"CustomApproverTag\";s:0:\"\";s:14:\"OrganizationId\";s:32:\"yDCdcUU53c9c88UE3LRjhx0RHDA2NF4n\";s:16:\"OrganizationName\";s:36:\"上海申瑞人力资源有限公司\";s:6:\"SignId\";s:32:\"yDtCrUUl77p6hdUyB0wakRshoYo8xHuM\";s:16:\"ApproverRoleName\";s:36:\"上海申瑞人力资源有限公司\";}i:1;O:52:\"TencentCloud\\Ess\\V20201111\\Models\\FlowApproverDetail\":15:{s:14:\"ApproveMessage\";s:140:\"发起方-上海申瑞人力资源有限公司以“工资查询系统后台-管理员手动撤销电子合同”的理由撤销当前合同\";s:11:\"ApproveName\";s:9:\"盖庆超\";s:13:\"ApproveStatus\";i:9;s:9:\"ReceiptId\";s:32:\"yDtCrUUl77gdwdUupriJVEI2uRXNPltv\";s:12:\"CustomUserId\";s:0:\"\";s:6:\"Mobile\";s:11:\"17685435572\";s:9:\"SignOrder\";i:1;s:11:\"ApproveTime\";i:0;s:11:\"ApproveType\";s:6:\"PERSON\";s:14:\"ApproverSource\";s:0:\"\";s:17:\"CustomApproverTag\";s:0:\"\";s:14:\"OrganizationId\";s:0:\"\";s:16:\"OrganizationName\";s:0:\"\";s:6:\"SignId\";s:32:\"yDtCrUUl77p62cUyB0wakyQWQVv4kBlV\";s:16:\"ApproverRoleName\";s:16:\"个人签署方1\";}}s:7:\"CcInfos\";a:0:{}s:7:\"Creator\";s:32:\"yDCdcUU53cznh4UEXKV7d8fT5LXyaXeg\";}', '6', 1741769367, 1741858020, 'yDtCrUUl7b0a19Uui9ulrvxYij2Yhn6j');
INSERT INTO `fa_contract_record` VALUES (7, 1, 'yDtCrUUl778zzaUy4F1YpRHIY0oN4xKy', 'O:48:\"TencentCloud\\Ess\\V20201111\\Models\\FlowDetailInfo\":10:{s:6:\"FlowId\";s:32:\"yDtCrUUl778zzaUy4F1YpRHIY0oN4xKy\";s:8:\"FlowName\";s:24:\"盖庆超的劳动合同\";s:8:\"FlowType\";s:0:\"\";s:10:\"FlowStatus\";i:6;s:11:\"FlowMessage\";s:140:\"发起方-上海申瑞人力资源有限公司以“工资查询系统后台-管理员手动撤销电子合同”的理由撤销当前合同\";s:15:\"FlowDescription\";s:0:\"\";s:9:\"CreatedOn\";i:1741769978;s:17:\"FlowApproverInfos\";a:2:{i:0;O:52:\"TencentCloud\\Ess\\V20201111\\Models\\FlowApproverDetail\":15:{s:14:\"ApproveMessage\";s:0:\"\";s:11:\"ApproveName\";s:9:\"张生龙\";s:13:\"ApproveStatus\";i:3;s:9:\"ReceiptId\";s:32:\"yDtCrUUl7uguyxUucGHGoRjoEbiBMSvp\";s:12:\"CustomUserId\";s:0:\"\";s:6:\"Mobile\";s:11:\"18201786888\";s:9:\"SignOrder\";i:0;s:11:\"ApproveTime\";i:1741769983;s:11:\"ApproveType\";s:16:\"ENTERPRISESERVER\";s:14:\"ApproverSource\";s:0:\"\";s:17:\"CustomApproverTag\";s:0:\"\";s:14:\"OrganizationId\";s:32:\"yDCdcUU53c9c88UE3LRjhx0RHDA2NF4n\";s:16:\"OrganizationName\";s:36:\"上海申瑞人力资源有限公司\";s:6:\"SignId\";s:32:\"yDtCrUUl778zzyUy4F1Yp1IM6jVrDpY5\";s:16:\"ApproverRoleName\";s:36:\"上海申瑞人力资源有限公司\";}i:1;O:52:\"TencentCloud\\Ess\\V20201111\\Models\\FlowApproverDetail\":15:{s:14:\"ApproveMessage\";s:140:\"发起方-上海申瑞人力资源有限公司以“工资查询系统后台-管理员手动撤销电子合同”的理由撤销当前合同\";s:11:\"ApproveName\";s:9:\"盖庆超\";s:13:\"ApproveStatus\";i:9;s:9:\"ReceiptId\";s:32:\"yDtCrUUl7uguy7UucGHGoR3wFWLuJHY6\";s:12:\"CustomUserId\";s:0:\"\";s:6:\"Mobile\";s:11:\"17685435572\";s:9:\"SignOrder\";i:1;s:11:\"ApproveTime\";i:0;s:11:\"ApproveType\";s:6:\"PERSON\";s:14:\"ApproverSource\";s:0:\"\";s:17:\"CustomApproverTag\";s:0:\"\";s:14:\"OrganizationId\";s:0:\"\";s:16:\"OrganizationName\";s:0:\"\";s:6:\"SignId\";s:32:\"yDtCrUUl778zzwUy4F1Ypvhdn0LG236T\";s:16:\"ApproverRoleName\";s:16:\"个人签署方1\";}}s:7:\"CcInfos\";a:0:{}s:7:\"Creator\";s:32:\"yDCdcUU53cznh4UEXKV7d8fT5LXyaXeg\";}', '6', 1741769982, 1741858020, 'yDtCrUUl7bvfqtUucGHGoG3jGmQvsw1O');
INSERT INTO `fa_contract_record` VALUES (8, 1, 'yDtCrUUl7714b4Uu2qDkrxotiSGHQ0Qg', 'O:48:\"TencentCloud\\Ess\\V20201111\\Models\\FlowDetailInfo\":10:{s:6:\"FlowId\";s:32:\"yDtCrUUl7714b4Uu2qDkrxotiSGHQ0Qg\";s:8:\"FlowName\";s:24:\"盖庆超的劳动合同\";s:8:\"FlowType\";s:0:\"\";s:10:\"FlowStatus\";i:6;s:11:\"FlowMessage\";s:140:\"发起方-上海申瑞人力资源有限公司以“工资查询系统后台-管理员手动撤销电子合同”的理由撤销当前合同\";s:15:\"FlowDescription\";s:0:\"\";s:9:\"CreatedOn\";i:1741770346;s:17:\"FlowApproverInfos\";a:2:{i:0;O:52:\"TencentCloud\\Ess\\V20201111\\Models\\FlowApproverDetail\":15:{s:14:\"ApproveMessage\";s:0:\"\";s:11:\"ApproveName\";s:9:\"张生龙\";s:13:\"ApproveStatus\";i:3;s:9:\"ReceiptId\";s:32:\"yDtCrUUl77s7xhUEkW4VySocJHbMR2t9\";s:12:\"CustomUserId\";s:0:\"\";s:6:\"Mobile\";s:11:\"18201786888\";s:9:\"SignOrder\";i:0;s:11:\"ApproveTime\";i:1741770350;s:11:\"ApproveType\";s:16:\"ENTERPRISESERVER\";s:14:\"ApproverSource\";s:0:\"\";s:17:\"CustomApproverTag\";s:0:\"\";s:14:\"OrganizationId\";s:32:\"yDCdcUU53c9c88UE3LRjhx0RHDA2NF4n\";s:16:\"OrganizationName\";s:36:\"上海申瑞人力资源有限公司\";s:6:\"SignId\";s:32:\"yDtCrUUl7714buUu2qDkruOGmVL9GB0x\";s:16:\"ApproverRoleName\";s:36:\"上海申瑞人力资源有限公司\";}i:1;O:52:\"TencentCloud\\Ess\\V20201111\\Models\\FlowApproverDetail\":15:{s:14:\"ApproveMessage\";s:140:\"发起方-上海申瑞人力资源有限公司以“工资查询系统后台-管理员手动撤销电子合同”的理由撤销当前合同\";s:11:\"ApproveName\";s:9:\"盖庆超\";s:13:\"ApproveStatus\";i:9;s:9:\"ReceiptId\";s:32:\"yDtCrUUl77s7x2UEkW4Vyu7AWLgjrSwj\";s:12:\"CustomUserId\";s:0:\"\";s:6:\"Mobile\";s:11:\"17685435572\";s:9:\"SignOrder\";i:1;s:11:\"ApproveTime\";i:0;s:11:\"ApproveType\";s:6:\"PERSON\";s:14:\"ApproverSource\";s:0:\"\";s:17:\"CustomApproverTag\";s:0:\"\";s:14:\"OrganizationId\";s:0:\"\";s:16:\"OrganizationName\";s:0:\"\";s:6:\"SignId\";s:32:\"yDtCrUUl7714baUu2qDkryoV8mXaxHTG\";s:16:\"ApproverRoleName\";s:16:\"个人签署方1\";}}s:7:\"CcInfos\";a:0:{}s:7:\"Creator\";s:32:\"yDCdcUU53cznh4UEXKV7d8fT5LXyaXeg\";}', '6', 1741770349, 1741858020, 'yDtCrUUl7bvfqtUucGHGoG3jGmQvsw1O');
INSERT INTO `fa_contract_record` VALUES (9, 1, 'yDtCrUUl77og0jUNCDFbuLef1GbxXcNC', 'O:48:\"TencentCloud\\Ess\\V20201111\\Models\\FlowDetailInfo\":10:{s:6:\"FlowId\";s:32:\"yDtCrUUl77og0jUNCDFbuLef1GbxXcNC\";s:8:\"FlowName\";s:24:\"盖庆超的劳动合同\";s:8:\"FlowType\";s:0:\"\";s:10:\"FlowStatus\";i:6;s:11:\"FlowMessage\";s:140:\"发起方-上海申瑞人力资源有限公司以“工资查询系统后台-管理员手动撤销电子合同”的理由撤销当前合同\";s:15:\"FlowDescription\";s:0:\"\";s:9:\"CreatedOn\";i:1741770517;s:17:\"FlowApproverInfos\";a:2:{i:0;O:52:\"TencentCloud\\Ess\\V20201111\\Models\\FlowApproverDetail\":15:{s:14:\"ApproveMessage\";s:0:\"\";s:11:\"ApproveName\";s:9:\"张生龙\";s:13:\"ApproveStatus\";i:3;s:9:\"ReceiptId\";s:32:\"yDtCrUUl77s7xhUEkW4VySocJHbMR2t9\";s:12:\"CustomUserId\";s:0:\"\";s:6:\"Mobile\";s:11:\"18201786888\";s:9:\"SignOrder\";i:0;s:11:\"ApproveTime\";i:1741770521;s:11:\"ApproveType\";s:16:\"ENTERPRISESERVER\";s:14:\"ApproverSource\";s:0:\"\";s:17:\"CustomApproverTag\";s:0:\"\";s:14:\"OrganizationId\";s:32:\"yDCdcUU53c9c88UE3LRjhx0RHDA2NF4n\";s:16:\"OrganizationName\";s:36:\"上海申瑞人力资源有限公司\";s:6:\"SignId\";s:32:\"yDtCrUUl77og08UNCDFbR4Es6nIOFmrB\";s:16:\"ApproverRoleName\";s:36:\"上海申瑞人力资源有限公司\";}i:1;O:52:\"TencentCloud\\Ess\\V20201111\\Models\\FlowApproverDetail\":15:{s:14:\"ApproveMessage\";s:140:\"发起方-上海申瑞人力资源有限公司以“工资查询系统后台-管理员手动撤销电子合同”的理由撤销当前合同\";s:11:\"ApproveName\";s:9:\"盖庆超\";s:13:\"ApproveStatus\";i:9;s:9:\"ReceiptId\";s:32:\"yDtCrUUl77s7x2UEkW4Vyu7AWLgjrSwj\";s:12:\"CustomUserId\";s:0:\"\";s:6:\"Mobile\";s:11:\"17685435572\";s:9:\"SignOrder\";i:1;s:11:\"ApproveTime\";i:0;s:11:\"ApproveType\";s:6:\"PERSON\";s:14:\"ApproverSource\";s:0:\"\";s:17:\"CustomApproverTag\";s:0:\"\";s:14:\"OrganizationId\";s:0:\"\";s:16:\"OrganizationName\";s:0:\"\";s:6:\"SignId\";s:32:\"yDtCrUUl77og0hUNCDFbRi5PgBXnZdQy\";s:16:\"ApproverRoleName\";s:16:\"个人签署方1\";}}s:7:\"CcInfos\";a:0:{}s:7:\"Creator\";s:32:\"yDCdcUU53cznh4UEXKV7d8fT5LXyaXeg\";}', '6', 1741770520, 1741858020, 'yDtCrUUl7bvfqtUucGHGoG3jGmQvsw1O');
INSERT INTO `fa_contract_record` VALUES (10, 1, 'yDtCrUUl77wr7rUx7x1hCElpvehmFO2R', 'O:48:\"TencentCloud\\Ess\\V20201111\\Models\\FlowDetailInfo\":10:{s:6:\"FlowId\";s:32:\"yDtCrUUl77wr7rUx7x1hCElpvehmFO2R\";s:8:\"FlowName\";s:24:\"盖庆超的劳动合同\";s:8:\"FlowType\";s:0:\"\";s:10:\"FlowStatus\";i:6;s:11:\"FlowMessage\";s:140:\"发起方-上海申瑞人力资源有限公司以“工资查询系统后台-管理员手动撤销电子合同”的理由撤销当前合同\";s:15:\"FlowDescription\";s:0:\"\";s:9:\"CreatedOn\";i:1741770760;s:17:\"FlowApproverInfos\";a:2:{i:0;O:52:\"TencentCloud\\Ess\\V20201111\\Models\\FlowApproverDetail\":15:{s:14:\"ApproveMessage\";s:0:\"\";s:11:\"ApproveName\";s:9:\"张生龙\";s:13:\"ApproveStatus\";i:3;s:9:\"ReceiptId\";s:32:\"yDtCrUUl77w1jhUfA1dCCkHjBEB1sBMx\";s:12:\"CustomUserId\";s:0:\"\";s:6:\"Mobile\";s:11:\"18201786888\";s:9:\"SignOrder\";i:0;s:11:\"ApproveTime\";i:1741770764;s:11:\"ApproveType\";s:16:\"ENTERPRISESERVER\";s:14:\"ApproverSource\";s:0:\"\";s:17:\"CustomApproverTag\";s:0:\"\";s:14:\"OrganizationId\";s:32:\"yDCdcUU53c9c88UE3LRjhx0RHDA2NF4n\";s:16:\"OrganizationName\";s:36:\"上海申瑞人力资源有限公司\";s:6:\"SignId\";s:32:\"yDtCrUUl77wr7lUx7x1hC1Pz6qyYz658\";s:16:\"ApproverRoleName\";s:36:\"上海申瑞人力资源有限公司\";}i:1;O:52:\"TencentCloud\\Ess\\V20201111\\Models\\FlowApproverDetail\":15:{s:14:\"ApproveMessage\";s:140:\"发起方-上海申瑞人力资源有限公司以“工资查询系统后台-管理员手动撤销电子合同”的理由撤销当前合同\";s:11:\"ApproveName\";s:9:\"盖庆超\";s:13:\"ApproveStatus\";i:9;s:9:\"ReceiptId\";s:32:\"yDtCrUUl77w1j2UfA1dCRhy1HP2YzoS1\";s:12:\"CustomUserId\";s:0:\"\";s:6:\"Mobile\";s:11:\"17685435572\";s:9:\"SignOrder\";i:1;s:11:\"ApproveTime\";i:0;s:11:\"ApproveType\";s:6:\"PERSON\";s:14:\"ApproverSource\";s:0:\"\";s:17:\"CustomApproverTag\";s:0:\"\";s:14:\"OrganizationId\";s:0:\"\";s:16:\"OrganizationName\";s:0:\"\";s:6:\"SignId\";s:32:\"yDtCrUUl77wr75Ux7x1hC8r7qLbG3BT8\";s:16:\"ApproverRoleName\";s:16:\"个人签署方1\";}}s:7:\"CcInfos\";a:0:{}s:7:\"Creator\";s:32:\"yDCdcUU53cznh4UEXKV7d8fT5LXyaXeg\";}', '6', 1741770763, 1741858020, 'yDtCrUUl7bvfqtUucGHGoG3jGmQvsw1O');
INSERT INTO `fa_contract_record` VALUES (11, 1, 'yDtCrUUl77y7z5UpkhPpvaFc3iKRsm7R', 'O:48:\"TencentCloud\\Ess\\V20201111\\Models\\FlowDetailInfo\":10:{s:6:\"FlowId\";s:32:\"yDtCrUUl77y7z5UpkhPpvaFc3iKRsm7R\";s:8:\"FlowName\";s:24:\"盖庆超的劳动合同\";s:8:\"FlowType\";s:0:\"\";s:10:\"FlowStatus\";i:6;s:11:\"FlowMessage\";s:140:\"发起方-上海申瑞人力资源有限公司以“工资查询系统后台-管理员手动撤销电子合同”的理由撤销当前合同\";s:15:\"FlowDescription\";s:0:\"\";s:9:\"CreatedOn\";i:1741770875;s:17:\"FlowApproverInfos\";a:2:{i:0;O:52:\"TencentCloud\\Ess\\V20201111\\Models\\FlowApproverDetail\":15:{s:14:\"ApproveMessage\";s:0:\"\";s:11:\"ApproveName\";s:9:\"张生龙\";s:13:\"ApproveStatus\";i:3;s:9:\"ReceiptId\";s:32:\"yDtCrUUl77w8chU8BYA8uWZ72kuAcwCx\";s:12:\"CustomUserId\";s:0:\"\";s:6:\"Mobile\";s:11:\"18201786888\";s:9:\"SignOrder\";i:0;s:11:\"ApproveTime\";i:1741770879;s:11:\"ApproveType\";s:16:\"ENTERPRISESERVER\";s:14:\"ApproverSource\";s:0:\"\";s:17:\"CustomApproverTag\";s:0:\"\";s:14:\"OrganizationId\";s:32:\"yDCdcUU53c9c88UE3LRjhx0RHDA2NF4n\";s:16:\"OrganizationName\";s:36:\"上海申瑞人力资源有限公司\";s:6:\"SignId\";s:32:\"yDtCrUUl77y7z0UpkhPpGe2BafScdYBS\";s:16:\"ApproverRoleName\";s:36:\"上海申瑞人力资源有限公司\";}i:1;O:52:\"TencentCloud\\Ess\\V20201111\\Models\\FlowApproverDetail\":15:{s:14:\"ApproveMessage\";s:140:\"发起方-上海申瑞人力资源有限公司以“工资查询系统后台-管理员手动撤销电子合同”的理由撤销当前合同\";s:11:\"ApproveName\";s:9:\"盖庆超\";s:13:\"ApproveStatus\";i:9;s:9:\"ReceiptId\";s:32:\"yDtCrUUl77w8c2U8BYA8EVocCQpW3WfS\";s:12:\"CustomUserId\";s:0:\"\";s:6:\"Mobile\";s:11:\"17685435572\";s:9:\"SignOrder\";i:1;s:11:\"ApproveTime\";i:0;s:11:\"ApproveType\";s:6:\"PERSON\";s:14:\"ApproverSource\";s:0:\"\";s:17:\"CustomApproverTag\";s:0:\"\";s:14:\"OrganizationId\";s:0:\"\";s:16:\"OrganizationName\";s:0:\"\";s:6:\"SignId\";s:32:\"yDtCrUUl77y7zpUpkhPpwFMeD70KZK98\";s:16:\"ApproverRoleName\";s:16:\"个人签署方1\";}}s:7:\"CcInfos\";a:0:{}s:7:\"Creator\";s:32:\"yDCdcUU53cznh4UEXKV7d8fT5LXyaXeg\";}', '6', 1741770878, 1741858020, 'yDtCrUUl7bvfqtUucGHGoG3jGmQvsw1O');
INSERT INTO `fa_contract_record` VALUES (12, 1, 'yDtCrUUl774a2pU9GuRvyvf6St7diC7y', 'O:48:\"TencentCloud\\Ess\\V20201111\\Models\\FlowDetailInfo\":10:{s:6:\"FlowId\";s:32:\"yDtCrUUl774a2pU9GuRvyvf6St7diC7y\";s:8:\"FlowName\";s:24:\"盖庆超的劳动合同\";s:8:\"FlowType\";s:0:\"\";s:10:\"FlowStatus\";i:6;s:11:\"FlowMessage\";s:157:\"发起方-上海申瑞人力资源有限公司以“工资查询系统后台-管理员手动重新生成合同(此合同撤销)”的理由撤销当前合同\";s:15:\"FlowDescription\";s:0:\"\";s:9:\"CreatedOn\";i:1741771129;s:17:\"FlowApproverInfos\";a:2:{i:0;O:52:\"TencentCloud\\Ess\\V20201111\\Models\\FlowApproverDetail\":15:{s:14:\"ApproveMessage\";s:0:\"\";s:11:\"ApproveName\";s:9:\"张生龙\";s:13:\"ApproveStatus\";i:3;s:9:\"ReceiptId\";s:32:\"yDtCrUUl7unz6zUEc3ZwnCqbbBWCxh4f\";s:12:\"CustomUserId\";s:0:\"\";s:6:\"Mobile\";s:11:\"18201786888\";s:9:\"SignOrder\";i:0;s:11:\"ApproveTime\";i:1741771133;s:11:\"ApproveType\";s:16:\"ENTERPRISESERVER\";s:14:\"ApproverSource\";s:0:\"\";s:17:\"CustomApproverTag\";s:0:\"\";s:14:\"OrganizationId\";s:32:\"yDCdcUU53c9c88UE3LRjhx0RHDA2NF4n\";s:16:\"OrganizationName\";s:36:\"上海申瑞人力资源有限公司\";s:6:\"SignId\";s:32:\"yDtCrUUl774a2nU9GuRvCjHwCuBju1Yh\";s:16:\"ApproverRoleName\";s:36:\"上海申瑞人力资源有限公司\";}i:1;O:52:\"TencentCloud\\Ess\\V20201111\\Models\\FlowApproverDetail\":15:{s:14:\"ApproveMessage\";s:157:\"发起方-上海申瑞人力资源有限公司以“工资查询系统后台-管理员手动重新生成合同(此合同撤销)”的理由撤销当前合同\";s:11:\"ApproveName\";s:9:\"盖庆超\";s:13:\"ApproveStatus\";i:9;s:9:\"ReceiptId\";s:32:\"yDtCrUUl7unz6mUEc3ZwnCDJajDSpw1r\";s:12:\"CustomUserId\";s:0:\"\";s:6:\"Mobile\";s:11:\"17685435572\";s:9:\"SignOrder\";i:1;s:11:\"ApproveTime\";i:0;s:11:\"ApproveType\";s:6:\"PERSON\";s:14:\"ApproverSource\";s:0:\"\";s:17:\"CustomApproverTag\";s:0:\"\";s:14:\"OrganizationId\";s:0:\"\";s:16:\"OrganizationName\";s:0:\"\";s:6:\"SignId\";s:32:\"yDtCrUUl774a2gU9GuRv6VZnIv4Nk1vT\";s:16:\"ApproverRoleName\";s:16:\"个人签署方1\";}}s:7:\"CcInfos\";a:0:{}s:7:\"Creator\";s:32:\"yDCdcUU53cznh4UEXKV7d8fT5LXyaXeg\";}', '6', 1741771132, 1741858020, 'yDtCrUUl7unz64UEc3ZwnRueWCoLDPCk');
INSERT INTO `fa_contract_record` VALUES (13, 1, 'yDtCrUUl77kw1oUEZXEGVxGAqTBGbDVH', 'O:48:\"TencentCloud\\Ess\\V20201111\\Models\\FlowDetailInfo\":10:{s:6:\"FlowId\";s:32:\"yDtCrUUl77kw1oUEZXEGVxGAqTBGbDVH\";s:8:\"FlowName\";s:24:\"盖庆超的劳动合同\";s:8:\"FlowType\";s:0:\"\";s:10:\"FlowStatus\";i:6;s:11:\"FlowMessage\";s:140:\"发起方-上海申瑞人力资源有限公司以“工资查询系统后台-管理员手动撤销电子合同”的理由撤销当前合同\";s:15:\"FlowDescription\";s:0:\"\";s:9:\"CreatedOn\";i:1741771451;s:17:\"FlowApproverInfos\";a:2:{i:0;O:52:\"TencentCloud\\Ess\\V20201111\\Models\\FlowApproverDetail\":15:{s:14:\"ApproveMessage\";s:0:\"\";s:11:\"ApproveName\";s:9:\"张生龙\";s:13:\"ApproveStatus\";i:3;s:9:\"ReceiptId\";s:32:\"yDtCrUUl77ze22UERKYlr89CYEubiddi\";s:12:\"CustomUserId\";s:0:\"\";s:6:\"Mobile\";s:11:\"18201786888\";s:9:\"SignOrder\";i:0;s:11:\"ApproveTime\";i:1741771456;s:11:\"ApproveType\";s:16:\"ENTERPRISESERVER\";s:14:\"ApproverSource\";s:0:\"\";s:17:\"CustomApproverTag\";s:0:\"\";s:14:\"OrganizationId\";s:32:\"yDCdcUU53c9c88UE3LRjhx0RHDA2NF4n\";s:16:\"OrganizationName\";s:36:\"上海申瑞人力资源有限公司\";s:6:\"SignId\";s:32:\"yDtCrUUl77kw1kUEZXEGVCu9yLn7OLAx\";s:16:\"ApproverRoleName\";s:36:\"上海申瑞人力资源有限公司\";}i:1;O:52:\"TencentCloud\\Ess\\V20201111\\Models\\FlowApproverDetail\":15:{s:14:\"ApproveMessage\";s:140:\"发起方-上海申瑞人力资源有限公司以“工资查询系统后台-管理员手动撤销电子合同”的理由撤销当前合同\";s:11:\"ApproveName\";s:9:\"盖庆超\";s:13:\"ApproveStatus\";i:9;s:9:\"ReceiptId\";s:32:\"yDtCrUUl77ze2rUERKYlrx0E0eXZlOv2\";s:12:\"CustomUserId\";s:0:\"\";s:6:\"Mobile\";s:11:\"17685435572\";s:9:\"SignOrder\";i:1;s:11:\"ApproveTime\";i:0;s:11:\"ApproveType\";s:6:\"PERSON\";s:14:\"ApproverSource\";s:0:\"\";s:17:\"CustomApproverTag\";s:0:\"\";s:14:\"OrganizationId\";s:0:\"\";s:16:\"OrganizationName\";s:0:\"\";s:6:\"SignId\";s:32:\"yDtCrUUl77kw13UEZXEGVNrrYrRkZy68\";s:16:\"ApproverRoleName\";s:16:\"个人签署方1\";}}s:7:\"CcInfos\";a:0:{}s:7:\"Creator\";s:32:\"yDCdcUU53cznh4UEXKV7d8fT5LXyaXeg\";}', '6', 1741771454, 1741858020, 'yDtCrUUl7unz64UEc3ZwnRueWCoLDPCk');
INSERT INTO `fa_contract_record` VALUES (14, 1, 'yDtCrUUl77icqyUuhDzO618iiV01u62d', 'O:48:\"TencentCloud\\Ess\\V20201111\\Models\\FlowDetailInfo\":10:{s:6:\"FlowId\";s:32:\"yDtCrUUl77icqyUuhDzO618iiV01u62d\";s:8:\"FlowName\";s:24:\"盖庆超的劳动合同\";s:8:\"FlowType\";s:0:\"\";s:10:\"FlowStatus\";i:6;s:11:\"FlowMessage\";s:140:\"发起方-上海申瑞人力资源有限公司以“工资查询系统后台-管理员手动撤销电子合同”的理由撤销当前合同\";s:15:\"FlowDescription\";s:0:\"\";s:9:\"CreatedOn\";i:1741771654;s:17:\"FlowApproverInfos\";a:2:{i:0;O:52:\"TencentCloud\\Ess\\V20201111\\Models\\FlowApproverDetail\":15:{s:14:\"ApproveMessage\";s:0:\"\";s:11:\"ApproveName\";s:9:\"张生龙\";s:13:\"ApproveStatus\";i:3;s:9:\"ReceiptId\";s:32:\"yDtCrUUl77irqwU64ex35qsGd9k03O8s\";s:12:\"CustomUserId\";s:0:\"\";s:6:\"Mobile\";s:11:\"18201786888\";s:9:\"SignOrder\";i:0;s:11:\"ApproveTime\";i:1741771659;s:11:\"ApproveType\";s:16:\"ENTERPRISESERVER\";s:14:\"ApproverSource\";s:0:\"\";s:17:\"CustomApproverTag\";s:0:\"\";s:14:\"OrganizationId\";s:32:\"yDCdcUU53c9c88UE3LRjhx0RHDA2NF4n\";s:16:\"OrganizationName\";s:36:\"上海申瑞人力资源有限公司\";s:6:\"SignId\";s:32:\"yDtCrUUl77icqwUuhDzO6xdYsWqI3THx\";s:16:\"ApproverRoleName\";s:36:\"上海申瑞人力资源有限公司\";}i:1;O:52:\"TencentCloud\\Ess\\V20201111\\Models\\FlowApproverDetail\":15:{s:14:\"ApproveMessage\";s:140:\"发起方-上海申瑞人力资源有限公司以“工资查询系统后台-管理员手动撤销电子合同”的理由撤销当前合同\";s:11:\"ApproveName\";s:9:\"盖庆超\";s:13:\"ApproveStatus\";i:9;s:9:\"ReceiptId\";s:32:\"yDtCrUUl77irqvU64ex3CCRpe355TPn1\";s:12:\"CustomUserId\";s:0:\"\";s:6:\"Mobile\";s:11:\"17685435572\";s:9:\"SignOrder\";i:1;s:11:\"ApproveTime\";i:0;s:11:\"ApproveType\";s:6:\"PERSON\";s:14:\"ApproverSource\";s:0:\"\";s:17:\"CustomApproverTag\";s:0:\"\";s:14:\"OrganizationId\";s:0:\"\";s:16:\"OrganizationName\";s:0:\"\";s:6:\"SignId\";s:32:\"yDtCrUUl77icqvUuhDzO6BGRoVFL1fP8\";s:16:\"ApproverRoleName\";s:16:\"个人签署方1\";}}s:7:\"CcInfos\";a:0:{}s:7:\"Creator\";s:32:\"yDCdcUU53cznh4UEXKV7d8fT5LXyaXeg\";}', '6', 1741771657, 1741858020, 'yDtCrUUl7unz64UEc3ZwnRueWCoLDPCk');
INSERT INTO `fa_contract_record` VALUES (15, 1, 'yDtCrUUl77c40bUuK4igeNyIKYccOIp8', 'O:48:\"TencentCloud\\Ess\\V20201111\\Models\\FlowDetailInfo\":10:{s:6:\"FlowId\";s:32:\"yDtCrUUl77c40bUuK4igeNyIKYccOIp8\";s:8:\"FlowName\";s:24:\"盖庆超的劳动合同\";s:8:\"FlowType\";s:0:\"\";s:10:\"FlowStatus\";i:6;s:11:\"FlowMessage\";s:140:\"发起方-上海申瑞人力资源有限公司以“工资查询系统后台-管理员手动撤销电子合同”的理由撤销当前合同\";s:15:\"FlowDescription\";s:0:\"\";s:9:\"CreatedOn\";i:1741771904;s:17:\"FlowApproverInfos\";a:2:{i:0;O:52:\"TencentCloud\\Ess\\V20201111\\Models\\FlowApproverDetail\":15:{s:14:\"ApproveMessage\";s:0:\"\";s:11:\"ApproveName\";s:9:\"张生龙\";s:13:\"ApproveStatus\";i:3;s:9:\"ReceiptId\";s:32:\"yDtCrUUl7uhfpdUucGHGowAvcwGkTNuS\";s:12:\"CustomUserId\";s:0:\"\";s:6:\"Mobile\";s:11:\"18201786888\";s:9:\"SignOrder\";i:0;s:11:\"ApproveTime\";i:1741771908;s:11:\"ApproveType\";s:16:\"ENTERPRISESERVER\";s:14:\"ApproverSource\";s:0:\"\";s:17:\"CustomApproverTag\";s:0:\"\";s:14:\"OrganizationId\";s:32:\"yDCdcUU53c9c88UE3LRjhx0RHDA2NF4n\";s:16:\"OrganizationName\";s:36:\"上海申瑞人力资源有限公司\";s:6:\"SignId\";s:32:\"yDtCrUUl77c40aUuK4igeO3kyrms7ES8\";s:16:\"ApproverRoleName\";s:36:\"上海申瑞人力资源有限公司\";}i:1;O:52:\"TencentCloud\\Ess\\V20201111\\Models\\FlowApproverDetail\":15:{s:14:\"ApproveMessage\";s:140:\"发起方-上海申瑞人力资源有限公司以“工资查询系统后台-管理员手动撤销电子合同”的理由撤销当前合同\";s:11:\"ApproveName\";s:9:\"盖庆超\";s:13:\"ApproveStatus\";i:9;s:9:\"ReceiptId\";s:32:\"yDtCrUUl7uhfncUucGHGoSk4FmYrFO9C\";s:12:\"CustomUserId\";s:0:\"\";s:6:\"Mobile\";s:11:\"17685435572\";s:9:\"SignOrder\";i:1;s:11:\"ApproveTime\";i:0;s:11:\"ApproveType\";s:6:\"PERSON\";s:14:\"ApproverSource\";s:0:\"\";s:17:\"CustomApproverTag\";s:0:\"\";s:14:\"OrganizationId\";s:0:\"\";s:16:\"OrganizationName\";s:0:\"\";s:6:\"SignId\";s:32:\"yDtCrUUl77c40yUuK4igeBT5kNeMKQmI\";s:16:\"ApproverRoleName\";s:16:\"个人签署方1\";}}s:7:\"CcInfos\";a:0:{}s:7:\"Creator\";s:32:\"yDCdcUU53cznh4UEXKV7d8fT5LXyaXeg\";}', '6', 1741771907, 1741858020, 'yDtCrUUl7uhfniUucGHGoEQohYMDr24m');
INSERT INTO `fa_contract_record` VALUES (18, 1, 'yDtCTUUlx2ko1bUur8jHQ6piHFvGNVYR', 'O:48:\"TencentCloud\\Ess\\V20201111\\Models\\FlowDetailInfo\":10:{s:6:\"FlowId\";s:32:\"yDtCTUUlx2ko1bUur8jHQ6piHFvGNVYR\";s:8:\"FlowName\";s:24:\"盖庆超的劳动合同\";s:8:\"FlowType\";s:0:\"\";s:10:\"FlowStatus\";i:6;s:11:\"FlowMessage\";s:140:\"发起方-上海申瑞人力资源有限公司以“工资查询系统后台-管理员手动撤销电子合同”的理由撤销当前合同\";s:15:\"FlowDescription\";s:0:\"\";s:9:\"CreatedOn\";i:1741857253;s:17:\"FlowApproverInfos\";a:2:{i:0;O:52:\"TencentCloud\\Ess\\V20201111\\Models\\FlowApproverDetail\":15:{s:14:\"ApproveMessage\";s:0:\"\";s:11:\"ApproveName\";s:9:\"张生龙\";s:13:\"ApproveStatus\";i:3;s:9:\"ReceiptId\";s:32:\"yDtCrUUl77w8chU8BYA8uWZ72kuAcwCx\";s:12:\"CustomUserId\";s:0:\"\";s:6:\"Mobile\";s:11:\"18201786888\";s:9:\"SignOrder\";i:0;s:11:\"ApproveTime\";i:1741857257;s:11:\"ApproveType\";s:16:\"ENTERPRISESERVER\";s:14:\"ApproverSource\";s:0:\"\";s:17:\"CustomApproverTag\";s:0:\"\";s:14:\"OrganizationId\";s:32:\"yDCdcUU53c9c88UE3LRjhx0RHDA2NF4n\";s:16:\"OrganizationName\";s:36:\"上海申瑞人力资源有限公司\";s:6:\"SignId\";s:32:\"yDtCTUUlx2ko1aUur8jHQyIXgJzOpD1k\";s:16:\"ApproverRoleName\";s:36:\"上海申瑞人力资源有限公司\";}i:1;O:52:\"TencentCloud\\Ess\\V20201111\\Models\\FlowApproverDetail\":15:{s:14:\"ApproveMessage\";s:140:\"发起方-上海申瑞人力资源有限公司以“工资查询系统后台-管理员手动撤销电子合同”的理由撤销当前合同\";s:11:\"ApproveName\";s:9:\"盖庆超\";s:13:\"ApproveStatus\";i:9;s:9:\"ReceiptId\";s:32:\"yDtCrUUl77w8c2U8BYA8EVocCQpW3WfS\";s:12:\"CustomUserId\";s:0:\"\";s:6:\"Mobile\";s:11:\"17685435572\";s:9:\"SignOrder\";i:1;s:11:\"ApproveTime\";i:0;s:11:\"ApproveType\";s:6:\"PERSON\";s:14:\"ApproverSource\";s:0:\"\";s:17:\"CustomApproverTag\";s:0:\"\";s:14:\"OrganizationId\";s:0:\"\";s:16:\"OrganizationName\";s:0:\"\";s:6:\"SignId\";s:32:\"yDtCTUUlx2ko1yUur8jHQEngPWRQRiep\";s:16:\"ApproverRoleName\";s:16:\"个人签署方1\";}}s:7:\"CcInfos\";a:0:{}s:7:\"Creator\";s:32:\"yDCdcUU53cznh4UEXKV7d8fT5LXyaXeg\";}', '6', 1741857256, 1741858020, 'yDtCrUUl7bvfqtUucGHGoG3jGmQvsw1O');
INSERT INTO `fa_contract_record` VALUES (19, 1, 'yDtCTUUlx2kn35UyEdnFrMDe234jEJA1', 'O:48:\"TencentCloud\\Ess\\V20201111\\Models\\FlowDetailInfo\":10:{s:6:\"FlowId\";s:32:\"yDtCTUUlx2kn35UyEdnFrMDe234jEJA1\";s:8:\"FlowName\";s:24:\"盖庆超的劳动合同\";s:8:\"FlowType\";s:0:\"\";s:10:\"FlowStatus\";i:6;s:11:\"FlowMessage\";s:140:\"发起方-上海申瑞人力资源有限公司以“工资查询系统后台-管理员手动撤销电子合同”的理由撤销当前合同\";s:15:\"FlowDescription\";s:0:\"\";s:9:\"CreatedOn\";i:1741857481;s:17:\"FlowApproverInfos\";a:2:{i:0;O:52:\"TencentCloud\\Ess\\V20201111\\Models\\FlowApproverDetail\":15:{s:14:\"ApproveMessage\";s:0:\"\";s:11:\"ApproveName\";s:9:\"张生龙\";s:13:\"ApproveStatus\";i:3;s:9:\"ReceiptId\";s:32:\"yDtCrUUl77irqwU64ex35qsGd9k03O8s\";s:12:\"CustomUserId\";s:0:\"\";s:6:\"Mobile\";s:11:\"18201786888\";s:9:\"SignOrder\";i:0;s:11:\"ApproveTime\";i:1741857486;s:11:\"ApproveType\";s:16:\"ENTERPRISESERVER\";s:14:\"ApproverSource\";s:0:\"\";s:17:\"CustomApproverTag\";s:0:\"\";s:14:\"OrganizationId\";s:32:\"yDCdcUU53c9c88UE3LRjhx0RHDA2NF4n\";s:16:\"OrganizationName\";s:36:\"上海申瑞人力资源有限公司\";s:6:\"SignId\";s:32:\"yDtCTUUlx2kn30UyEdnFrH12SWggPw3S\";s:16:\"ApproverRoleName\";s:36:\"上海申瑞人力资源有限公司\";}i:1;O:52:\"TencentCloud\\Ess\\V20201111\\Models\\FlowApproverDetail\":15:{s:14:\"ApproveMessage\";s:140:\"发起方-上海申瑞人力资源有限公司以“工资查询系统后台-管理员手动撤销电子合同”的理由撤销当前合同\";s:11:\"ApproveName\";s:9:\"盖庆超\";s:13:\"ApproveStatus\";i:9;s:9:\"ReceiptId\";s:32:\"yDtCrUUl77irqvU64ex3CCRpe355TPn1\";s:12:\"CustomUserId\";s:0:\"\";s:6:\"Mobile\";s:11:\"17685435572\";s:9:\"SignOrder\";i:1;s:11:\"ApproveTime\";i:0;s:11:\"ApproveType\";s:6:\"PERSON\";s:14:\"ApproverSource\";s:0:\"\";s:17:\"CustomApproverTag\";s:0:\"\";s:14:\"OrganizationId\";s:0:\"\";s:16:\"OrganizationName\";s:0:\"\";s:6:\"SignId\";s:32:\"yDtCTUUlx2kn3pUyEdnFryTb5g8VxO47\";s:16:\"ApproverRoleName\";s:16:\"个人签署方1\";}}s:7:\"CcInfos\";a:0:{}s:7:\"Creator\";s:32:\"yDCdcUU53cznh4UEXKV7d8fT5LXyaXeg\";}', '6', 1741857484, 1741858020, 'yDtCrUUl7unz64UEc3ZwnRueWCoLDPCk');
COMMIT;

-- ----------------------------
-- Table structure for fa_ems
-- ----------------------------
DROP TABLE IF EXISTS `fa_ems`;
CREATE TABLE `fa_ems` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `event` varchar(30) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '事件',
  `email` varchar(100) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '邮箱',
  `code` varchar(10) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '验证码',
  `times` int unsigned NOT NULL DEFAULT '0' COMMENT '验证次数',
  `ip` varchar(30) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT 'IP',
  `createtime` bigint DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='邮箱验证码表';

-- ----------------------------
-- Table structure for fa_msglog
-- ----------------------------
DROP TABLE IF EXISTS `fa_msglog`;
CREATE TABLE `fa_msglog` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `mobile` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '手机号',
  `code` varchar(10) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '验证码',
  `status` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '状态：1成功，0失败',
  `dateline` varchar(50) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '时间',
  `result` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '接口返回结果',
  PRIMARY KEY (`id`),
  KEY `mobile` (`mobile`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='短信验证码发送记录表';

-- ----------------------------
-- Records of fa_msglog
-- ----------------------------
BEGIN;
INSERT INTO `fa_msglog` VALUES (1, '17086263668', '474244', 1, '2024-12-06 13:59:55', 'a:4:{s:7:\"Message\";s:2:\"OK\";s:9:\"RequestId\";s:36:\"DE412209-C085-506B-BDB0-E43923756867\";s:4:\"Code\";s:2:\"OK\";s:5:\"BizId\";s:20:\"852901833464795618^0\";}');
INSERT INTO `fa_msglog` VALUES (2, '17086263668', '947096', 1, '2025-02-19 15:27:23', 'a:4:{s:7:\"Message\";s:2:\"OK\";s:9:\"RequestId\";s:36:\"68C4622A-DF05-5992-8FE9-506F34CA0C19\";s:4:\"Code\";s:2:\"OK\";s:5:\"BizId\";s:20:\"270811039950044250^0\";}');
INSERT INTO `fa_msglog` VALUES (3, '17086263668', '151491', 1, '2025-03-10 14:34:41', 'a:4:{s:7:\"Message\";s:2:\"OK\";s:9:\"RequestId\";s:36:\"0E231E4D-AE4A-5218-BA99-73D5BE6A8124\";s:4:\"Code\";s:2:\"OK\";s:5:\"BizId\";s:20:\"937323741588482153^0\";}');
COMMIT;

-- ----------------------------
-- Table structure for fa_salary
-- ----------------------------
DROP TABLE IF EXISTS `fa_salary`;
CREATE TABLE `fa_salary` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '姓名',
  `idcard` varchar(50) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '身份证号',
  `mobile` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `company_name` varchar(200) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '公司名称',
  `year` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '年份',
  `month` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '月份',
  `other` text COLLATE utf8mb4_general_ci NOT NULL,
  `createtime` bigint DEFAULT NULL COMMENT '创建时间',
  `updatetime` bigint DEFAULT NULL COMMENT '更新时间',
  `deletetime` bigint DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `idcard` (`idcard`),
  KEY `company_name` (`company_name`),
  KEY `mobile` (`mobile`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='工资表';

-- ----------------------------
-- Records of fa_salary
-- ----------------------------
BEGIN;
INSERT INTO `fa_salary` VALUES (1, '张三', '3706881993111142730', '17086263668', '腾讯', '2025', '1', 'a:8:{i:0;a:2:{s:4:\"name\";s:12:\"基本工资\";s:5:\"value\";s:7:\"¥15000\";}i:1;a:2:{s:4:\"name\";s:12:\"岗位津贴\";s:5:\"value\";s:4:\"2000\";}i:2;a:2:{s:4:\"name\";s:12:\"绩效奖金\";s:5:\"value\";s:4:\"5000\";}i:3;a:2:{s:4:\"name\";s:12:\"交通补贴\";s:5:\"value\";s:3:\"500\";}i:4;a:2:{s:4:\"name\";s:12:\"餐饮补贴\";s:5:\"value\";s:3:\"800\";}i:5;a:2:{s:4:\"name\";s:12:\"实发工资\";s:5:\"value\";s:5:\"23300\";}i:6;a:2:{s:4:\"name\";s:13:\"其它项目1\";s:5:\"value\";s:4:\"2222\";}i:7;a:2:{s:4:\"name\";s:13:\"其它项目2\";s:5:\"value\";s:4:\"1111\";}}', 1741588447, 1741588455, NULL);
COMMIT;

-- ----------------------------
-- Table structure for fa_sms
-- ----------------------------
DROP TABLE IF EXISTS `fa_sms`;
CREATE TABLE `fa_sms` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `event` varchar(30) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '事件',
  `mobile` varchar(20) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '手机号',
  `code` varchar(10) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '验证码',
  `times` int unsigned NOT NULL DEFAULT '0' COMMENT '验证次数',
  `ip` varchar(30) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT 'IP',
  `createtime` bigint unsigned DEFAULT '0' COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='短信验证码表';

-- ----------------------------
-- Table structure for fa_staff
-- ----------------------------
DROP TABLE IF EXISTS `fa_staff`;
CREATE TABLE `fa_staff` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '姓名',
  `gender` enum('0','1','2') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '1' COMMENT '性别:1=男,2=女',
  `mobile` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '手机号',
  `idcard` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '身份证号',
  `currentAddress` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '现住址',
  `permanentAddress` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '户籍地址',
  `urgent_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '紧急联系人姓名',
  `urgent_relation` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '与紧急联系人关系',
  `urgent_mobile` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '紧急联系人电话',
  `work_experience` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '工作经历',
  `bank_cardnum` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '银行卡号',
  `bankName` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '开户行',
  `company_id` int unsigned NOT NULL DEFAULT '0' COMMENT '入职公司',
  `createtime` bigint DEFAULT NULL COMMENT '创建时间',
  `updatetime` bigint DEFAULT NULL COMMENT '更新时间',
  `deletetime` bigint DEFAULT NULL COMMENT '删除时间',
  `flowid` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '合同流id',
  `contract_start_date` date DEFAULT NULL COMMENT '合同开始日期',
  `contract_end_date` date DEFAULT NULL COMMENT '合同结束日期',
  `internship_months` int unsigned NOT NULL DEFAULT '0' COMMENT '试用期几个月',
  `internship_start_date` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '试用期开始日期',
  `internship_end_date` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '试用期结束日期',
  `h5linkdata` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT 'h5链接相关数据',
  `contract_status` enum('0','1','2','3','4','5','6','7','8','9','10','21') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '合同状态:0=未开启流程,1=待签署,2=部分签署,3=已拒签,4=已签署,5=已过期,6=已撤销,7=未开启流程(合同中存在填写环节),8=等待填写,9=部分填写,10=已拒填,21=已解除',
  `templateId` varchar(100) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '合同模版id',
  `other_data` text COLLATE utf8mb4_general_ci COMMENT '合同补充参数',
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `mobile` (`mobile`),
  KEY `idcard` (`idcard`),
  KEY `contract_status` (`contract_status`),
  KEY `flowid` (`flowid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='员工表';

-- ----------------------------
-- Records of fa_staff
-- ----------------------------
BEGIN;
INSERT INTO `fa_staff` VALUES (1, '盖庆超', '1', '17685435572', '370682199211142730', '山东烟台', '山东青岛', '张亮', '父子', '15724956988', 'sdfsdfas', '234235353453', '中国银行', 3, 1733464808, 1741768637, NULL, 'yDtCTUUlx2kn35UyEdnFrMDe234jEJA1', '2024-12-06', '2025-12-06', 3, '2024-12-06', '2025-03-06', 'a:2:{s:20:\"FlowApproverUrlInfos\";a:1:{i:0;O:53:\"TencentCloud\\Ess\\V20201111\\Models\\FlowApproverUrlInfo\":5:{s:7:\"SignUrl\";s:28:\"https://essurl.cn/mqsyUJkbge\";s:12:\"ApproverType\";i:1;s:12:\"ApproverName\";s:9:\"盖庆超\";s:14:\"ApproverMobile\";s:11:\"17685435572\";s:7:\"LongUrl\";s:346:\"https://quick.qian.tencent.com/home?ApproverIdCardNumber=MyoqKioqKioqKioqKioqKiow&ApproverMobile=MTc2KioqKjU1NzI%3D&ApproverName=%25E7%259B%2596%252A%25E8%25B6%2585&ApproverType=1&Code=yDtCTUUlx2k2fxUyhgWQ6ErXYr2d3gjz&CodeType=QUICK&DeviceStore=1&FlowId=yDtCTUUlx2kn35UyEdnFrMDe234jEJA1&ShowHeader=1&shortKey=yDtCTUVCFs6lkB57vA54&token=mqsyUJkbge\";}}s:9:\"RequestId\";s:36:\"e0200cf5-5374-40ed-b5ba-af27facd783d\";}', '6', 'yDtCrUUl7unz64UEc3ZwnRueWCoLDPCk', 'a:4:{s:18:\"合同期限几年\";s:1:\"6\";s:9:\"月工资\";s:4:\"7000\";s:18:\"试用期月工资\";s:4:\"5000\";s:21:\"每月几号发工资\";s:2:\"20\";}');
COMMIT;

-- ----------------------------
-- Table structure for fa_test
-- ----------------------------
DROP TABLE IF EXISTS `fa_test`;
CREATE TABLE `fa_test` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `user_id` int DEFAULT '0' COMMENT '会员ID',
  `admin_id` int DEFAULT '0' COMMENT '管理员ID',
  `category_id` int unsigned DEFAULT '0' COMMENT '分类ID(单选)',
  `category_ids` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '分类ID(多选)',
  `tags` varchar(255) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '标签',
  `week` enum('monday','tuesday','wednesday') COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '星期(单选):monday=星期一,tuesday=星期二,wednesday=星期三',
  `flag` set('hot','index','recommend') COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '标志(多选):hot=热门,index=首页,recommend=推荐',
  `genderdata` enum('male','female') COLLATE utf8mb4_general_ci DEFAULT 'male' COMMENT '性别(单选):male=男,female=女',
  `hobbydata` set('music','reading','swimming') COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '爱好(多选):music=音乐,reading=读书,swimming=游泳',
  `title` varchar(100) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '标题',
  `content` text COLLATE utf8mb4_general_ci COMMENT '内容',
  `image` varchar(100) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '图片',
  `images` varchar(1500) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '图片组',
  `attachfile` varchar(100) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '附件',
  `keywords` varchar(255) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '关键字',
  `description` varchar(255) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '描述',
  `city` varchar(100) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '省市',
  `array` varchar(255) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '数组:value=值',
  `json` varchar(255) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '配置:key=名称,value=值',
  `multiplejson` varchar(1500) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '二维数组:title=标题,intro=介绍,author=作者,age=年龄',
  `price` decimal(10,2) unsigned DEFAULT '0.00' COMMENT '价格',
  `views` int unsigned DEFAULT '0' COMMENT '点击',
  `workrange` varchar(100) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '时间区间',
  `startdate` date DEFAULT NULL COMMENT '开始日期',
  `activitytime` datetime DEFAULT NULL COMMENT '活动时间(datetime)',
  `year` year DEFAULT NULL COMMENT '年',
  `times` time DEFAULT NULL COMMENT '时间',
  `refreshtime` bigint DEFAULT NULL COMMENT '刷新时间',
  `createtime` bigint DEFAULT NULL COMMENT '创建时间',
  `updatetime` bigint DEFAULT NULL COMMENT '更新时间',
  `deletetime` bigint DEFAULT NULL COMMENT '删除时间',
  `weigh` int DEFAULT '0' COMMENT '权重',
  `switch` tinyint(1) DEFAULT '0' COMMENT '开关',
  `status` enum('normal','hidden') COLLATE utf8mb4_general_ci DEFAULT 'normal' COMMENT '状态',
  `state` enum('0','1','2') COLLATE utf8mb4_general_ci DEFAULT '1' COMMENT '状态值:0=禁用,1=正常,2=推荐',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='测试表';

-- ----------------------------
-- Records of fa_test
-- ----------------------------
BEGIN;
INSERT INTO `fa_test` VALUES (1, 1, 1, 12, '12,13', '互联网,计算机', 'monday', 'hot,index', 'male', 'music,reading', '我是一篇测试文章', '<p>我是测试内容</p>', '/assets/img/avatar.png', '/assets/img/avatar.png,/assets/img/qrcode.png', '/assets/img/avatar.png', '关键字', '我是一篇测试文章描述，内容过多时将自动隐藏', '广西壮族自治区/百色市/平果县', '[\"a\",\"b\"]', '{\"a\":\"1\",\"b\":\"2\"}', '[{\"title\":\"标题一\",\"intro\":\"介绍一\",\"author\":\"小明\",\"age\":\"21\"}]', 0.00, 0, '2020-10-01 00:00:00 - 2021-10-31 23:59:59', '2017-07-10', '2017-07-10 18:24:45', 2017, '18:24:45', 1491635035, 1491635035, 1491635035, NULL, 0, 1, 'normal', '1');
COMMIT;

-- ----------------------------
-- Table structure for fa_version
-- ----------------------------
DROP TABLE IF EXISTS `fa_version`;
CREATE TABLE `fa_version` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `oldversion` varchar(30) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '旧版本号',
  `newversion` varchar(30) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '新版本号',
  `packagesize` varchar(30) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '包大小',
  `content` varchar(500) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '升级内容',
  `downloadurl` varchar(255) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '下载地址',
  `enforce` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '强制更新',
  `createtime` bigint DEFAULT NULL COMMENT '创建时间',
  `updatetime` bigint DEFAULT NULL COMMENT '更新时间',
  `weigh` int NOT NULL DEFAULT '0' COMMENT '权重',
  `status` varchar(30) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '状态',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='版本表';

-- ----------------------------
-- Table structure for fa_yearmonth
-- ----------------------------
DROP TABLE IF EXISTS `fa_yearmonth`;
CREATE TABLE `fa_yearmonth` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `year` varchar(50) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '年份',
  `month` varchar(50) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '月份',
  `createtime` bigint DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='工资管理';

SET FOREIGN_KEY_CHECKS = 1;
